there are three basic areas where you want to create indexes.

1. the where clause - creating an index which exactly matches the where clause will give a bookmark lookup -...

I've found that this idea isn't generally well recieved, to me it sounds good as a limit to having resource sat around doing nothing - your failover ( passive )...

there are just so many posts about memory on 64bit - why oh why didn't microsoft make this aspect of setup clear?

I only use enterpise x64 so if it's std...

don't you just love clustering? are you sure you've checked all your logs across the entire setup?

why why why ?????? SQL is set based why must developers constantly seek to overcomplicate things - you only need a lookup table.

I've encountered a software release (...

I know all about this and as I say i wouldn't normally use a float datatype, the issue remains that the identical data gives different results ( consistantly ) on...

consider that I work for blue chips and I assist in recruiting production DBA's. The roles always ask for performance tuning and diagnostic skills, if you don't know what a...

Grant I do so agree, the lack of basic stuff is truly frightening and even more so when you look to see where they work and how much they get...

use osql

John - I so agree - trouble was the post wasn't ironic enough to be properly funny!!

btw. I'd never ask the format of a dbcc command in an interview and...

without seeing the queries it's difficult to be precise. I don't generally use includes in index creation. all suggested indexes are different it really depends upon the queries I'm...

yes no problem- why do you ask ?

is this an active/passive cluster?

ah you do have to be careful with single user mode, any number of connections may grab your one and only connection.Alter database will normally put it back regardless of...

partitioning is a subject which can't be covered in a simple set of posts - I'm sure there's just been a couple of good articles on the forum ( last...