I hear you, there isn't really a published algorithm.

Because of that it has the chance of changing in SP's, CU's, or versions. You know how it is....

And Great Question Steve!

Peter Trast (5/16/2011)

---

Great Question and a lucky guess so I read up on it. The strangest statement in the msdn article I read (http://msdn.microsoft.com/en-us/library/cc280464.aspx) was:

" If the space gained by...

Hi Jamie,

A Heap is just a Table without a Clustered Index.

Think of it like a filing cabinet, with a heap, you just put all new documents to be...

Good question, I know instinctively that each object get's a new set of allocation Units per partition, but I normally do this with clustered indexes, and not heaps.

I went out...

I feel like I had to really fight to become a DBA, I started out as an involuntary DBA but I found after a couple years that the SQL part...

Thanks for throwing this together Steve, it makes it a lot more interesting to watch the games, anyone of us could be out as of this Friday, depending on how...

Good question the extra "," almost threw me

Hi Henry,

Did the connections come back up as the other server started to come back online from a reboot? Is this a Prod Server? ...

Glad I could help!

I've always had a Network Guy that I went to, normally there is a range of IP Addresses that are available on the network and they should...

When you set up a Cluster there are several components that come into play.

1. your servers, we'll call then Node1 & Node2

2. your storage, we'll say this is on a...

I'm game

laddu4700 (3/11/2011)

---

Hi,

I am trying to shrink a SQL Server 2005 user dev database, but mdf file size exists same.

Below are the details

FileSizeMBUsedSpaceMBUnusedSpaceMBGrowthPctGrowthMBDBFileName

3324.56 3266.6357.94NULL1Test

1.50.660.8410NULLTest_Log

And Backup file size is 3267...

Hey Henry,

Your right normally this should not cause any outage, it is called the Passive node for a reason.

Is this a Windows...

Great Question! Paul's Myth a day pdf is available for Download. It is well worth the read!

http://www.sqlskills.com/BLOGS/PAUL/post/Myths-and-misconceptions-60-page-PDF-of-blog-posts.aspx