http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/668034ed-a47e-4bd3-bedc-acf9cb2b11dc

shows fundamental differences. For details you must check BOL.

I managed to find the link to authenticate that.:-)

http://msdn.microsoft.com/en-us/library/ms190969(SQL.90).aspx

The first picture on this site explains about row offsets..

Row offsets for all rows present in a page are stored at the end of the page. the first offset is stored at the extreme end of the page which...

i'm not sure why they're adding 2 but it does factor page header which is 96 bytes. There is one more factor to be considered, from the end of the...

ekonagu (7/2/2009)

---

actually if we are crating a linked server eith script

EXEC sp_addlinkedserver 'Server1', N'SQL Server'

how u come toknow to which server in the network is geting connected ?we need to...

John Marsh (7/2/2009)

---

Hello Sourav,

I would not recommend deleting and recreating...

you can find estimated table size using the formula i mentioned.

Yep i too tried to run that query and gave that error.

you can query this to get row count and...

There are many scripts here. you may want to start with this one.

http://www.sqlservercentral.com/articles/Administration/findingtablespace/1936/

To find the estimate table size there is a formula

rows per page = 8096/row size

row size =...

😉 Never mind. we all do get confused in most basic things at times.

thanks for the feedback 🙂

yes as u put new objects and pump data to tables, size of your mdf will grow if there...

to increase the timeout period, you can run

sp_configure 'remote login timeout', 30

go

reconfigure with override

go

here 30 secs will be timeout duration.

ekonagu (7/1/2009)

---

Hai to All

i need some help in creating linkedserver.while creating the linkedserver the name should be same as the server name rt?? like \\server1

and

i have created like this thru...

Sourav Mukherjee (7/1/2009)

---

Thanks Pradeep for your response.

Option:2 is fine, but the drawback is: If my T-log backups are taken in 15 mins (generally stad way of taking it) interval then...

i was of the opinion that data files get filled proportionally and log files in round robin sequence. I cant seem to find related articles...