jlahdenpera (12/18/2014)

---

The downsides of auto increment columns are well discussed and documented.

I have tables with > 5,000,000 records with Guids as primary keys. These tables contain static data so clustered...

Great article. This particular issue is a huge problem and was in place for many years in my current environment which we now have to go back and fix...

sorry, must have missed it.

Great article, but probably needs to have a disclaimer since it doesn't necessarily apply to 2012.

mtucker-732014 (10/28/2013)

---

It is fun to see how people rationalise things that are clearly not rational, especially when there are so many counter examples

my favourite so far was that it is...

mtucker-732014 (10/27/2013)

---

Keith Hays (10/27/2013)

---

...and I can tell you that if you show up for an interview or a meeting the first time I meet you and you look like you...

You have it exactly correct KWymore. It is much harder to correct a visual first impression than to make a good one in the first place.

For me clothing is tool to be used at work just like any other. If I know I am going to be in a meeting with my most immediate...

for those trying to avoid this performance and administration nightmare:

1. consolidate your databases onto like instances for workload type

2. consolidate Instances onto clustered physical servers

3. have plan to implement 2012...

Jo Pattyn (12/17/2011)

---

Good point. Virtualization has many benefits: easy migration, lab testing, flexible in hardware resource, not so dependent on hardware-age

My mayor gripe with virtualization is the licensing model some...

The licensing model is changing for SQL Server this year 2012. CPU licensing and server/cal is going away for enterprise. licensing is moving to per core with a...

bdavey (5/3/2010)

---

Thanks Lynn, Greg, & Steve. I think I see the error of may ways now. Let me define this a little more.

It is a single cluster environment (1 active,...

I have been a SQL Server DBA for about 12 years. I have experience with both VMWare, hyperv, and of course physical. The biggest lie being told to...

The should be dumped to a flat file and bulk inserted in bulk logged mode.

Hope this helps.

You best bet is to first upgrade the existing cluster to sp3. This will allow you to run sp3 on the new nodes in /passive mode from the new...