andrew gothard (5/3/2014)

---

Jeremy Brown (5/1/2014)

---

Jack Corbett (4/3/2014)

---

Andrew,

Here's my explanation for pluralization. Because the table doesn't contain a car it contains cars. The row is a car...

I think I've seen that tried before... 🙂

Jack Corbett (4/3/2014)

---

Andrew,

Here's my explanation for pluralization. Because the table doesn't contain a car it contains cars. The row is a car the table is a...

So Gail, what does cat barf in a stored proc look like?

...Just giving you a hard time. That comment made me chuckle. Can't tell you how many times I've...

Technically, if you don't know the value, you don't have a complete representation of the entity.

If you assume a value, you're basically saying that the current "measure" here is 0...

I agree that the naming standards can go insanely overboard. However your comment about starting the name with the verb is one I disagree with immensely. When you have a...

I find more often than not, people go overboard on naming standards (in my honest and humble opinion).

I know I'm probably going to catch a lot of flames...

From what I understand, if you convert any table to use the clustered columnstore format, you're implicitly using this. It stores the first 10k rows (I believe) in the...

Just to note: SQL 2008 scheduler does not reguard NUMA for thread assignment in parallelism. The thread has a chance of running on the same node, or it...

I really want to know the answer to this as well.

I have to say, most of the information on SQL Server and NUMA that I've found online is sparse at...

Hey Gail, I was just wondering if you ever had a...

Totally agree. Perhaps I'll take 1/4 of the data, run the change, watching I/O and total time, as well as t-log growth. Multiply that by 4 and I should have...

Fortunately in this case, its not part of the partition key.

Unfortunately, because of the size of the tables involved, getting a representative "test" environment set up for a dry run...

pradyothana (5/18/2009)

---

Hi,

After establishment of logshipping if we took the full back up of the database from the primary server this will sure breaks the Log shipping.

Once we take the full...

Your newsletter. I want it. 😉