our reporting people are notorious for creating tables with no PK's and other weird things and having queries that do 500000 reads to return 2 rows or go crazy with...

start with the execution plan

only in an ideal world

in the real world CSR reps and sales people put down whatever the slang name is for something or they put in trouble tickets that something...

zip codes are one thing, but a lot of times you have varchar data where a sales person fills it out and just puts in the wrong data for whatever...

there are no good and bad or black or white in SQL, only gray areas and what is good for your situation

we have very few FK's where i work as...

HP just came out with the DL 580 G4

4 quad core CPU's, up to 256GB of RAM and something like 16 drive bays

no, MSSQL should be like MySQL in that i can buy 10 or so HP DL 360's, set them up and run one instance of SQL across them. if one...

i use Veritas Netbackup Enterprise with a 7 year old tape library. we have around 30 SQL servers so using native SQL backup is too much time to manage.

i use...

MSSQL needs a federated design like Oracle and MySQL where you use a bunch of cheapo boxes and don't need MSCS clusters. if one fails you simply reroll and replace...

for all the enterprise applications, MySQL has a lot of other software behind it to be highly available. M is only one letter in LAMPS

just add /3GB to the long row of crap

i think /fastdetect is in the row you need to add it to. or go to the knowledge base and run a...

it's simple

SQL 2005 and Oracle are real db servers and MySQL is not. i was helping our devs with it on some webserver a few months back and there is...

how much RAM is the server set for maximum memory? i would also run a trace to see how efficient the table/index structure is. nothing like a bad schema or...

i would not restore any system db's from sql 2000 to 2005

in my case i had a staging server to hold logins, dts, jobs, etc. for logins i just input...

i've never done a 3 node cluster, but with our 2 node it's always like this

fail over to one node

upgrade an instance

fail over to the other node

upgrade the other instance

make...