I believe the rule regarding indexes (clustered or not) is the infamous "It Depends".... because your choice of indexing style really does depend upon how you're planning to access your...

From examining several phones belonging to various people, I have determined that the "fingerswipe password" is essentially useless as security. It can perhaps prevent someone from accidentally opening your phone...

I'm a silver Mercedes Benz 600 Limousine. Elegant and stately. 😉

( http://www.m-100.cc/600/index.html )

Currently we own a silver 2008 Mercedes Benz E320 Diesel and a black 2005 Mercedes Benz...

Thanks for posting a basic Powershell article. Most Powershell articles I've read assume that I already know most of how it works - but I don't because I haven't started...

The only thing not mentioned, or emphasized in this is the performance of using APPL.

For tiny databases / small result sets, this is awesome. For large result sets, it's terrible....

Happy New Year !

Let's celebrate the beginning of (hopefully) a far better year. May all your backups and DBCC checkdb results be excellent. 😀

12-needle embroidery machine, and a bottle of Haut-Brion. 😀

Heck, I'd settle for some fun SQL Tools that monitor performance and can generate an impressive amount of test data that's...

Merry Christmas to my #SQLFamily!

Reindeer steaks are delicious, though they're very difficult to find in the US....so we'll have a nice beef steak and a stellar wine for our...

Definitely the trip to space for me 🙂

Taking the cash is a bad plan because the government will steal about 60% of it in the form of taxes....

I got it right, but only because I've read Grant Fritchey's book about execution plans. 🙂

I'm in Tech support, so I have to work with a variety of versions: we have customers on SQL2000, SQL2005, SQL 2008 + SQL 2008 R2 (and all patch levels...

Try watching some old SF from the late '60s / early '70s - series like

Blake's 7

Space 1999

UFO

Also consider attending a steampunk convention or anime convention or SF convention - there...

I have a practical example of where "Select *" fails:

Our product has a VIEW called "Customerz" defined as "SELECT * FROM CustomerTable" (view & table name changed to...

Dear Santa,

I've been a good little girl and having SQL Monitor and a spiffy iPad would really make my year.

🙂

I've left a bottle of 2005 Chateau-Neuf-du-Pape, a clean glass,...

I don't listen to music when I work because

(1) headphones hurt my ears after the first 15 minutes

(2) If I do try to listen to music, I spend...