You need one more right paren after as "varchar(6)" in your code... and it doesn't work if last_occurrence_time < 100000. A couple ways to do that--...
This (http://support.microsoft.com/kb/912389) link is reminiscent of an issue (http://support.microsoft.com/kb/967983/) we hit a week or 2 back; a...
Just to confirm: You know you are grouping on but not SELECTing X.column2, right? These columns are indexed, right? (X.column1 and B.column1) And...
(Arriving late to the party) I could be wrong, but... The lower your fill factor the fewer records you will initially have per page. So to get N...
This is an old subject I know but I continue to get emails about threads I have NOT subscribed to. My profile is set so I would expect to get no...
Could be many things, but confirm that you are not automatically shrinking your tlog or db size; if for example you had autoshrink tlog ON and your...
(Slight sidetrack) I worked in a cafeteria once, and one week the boss put up the time sheet for the "Hydro-ceramic Engineers". You know them as dish...
If you want row count for ALL rows in the table-- and can tolerate a little inaccuracy (but I think this was resolved in sql2005) look at: select...
If the need is not urgent... and you can wait until after... SP1.... you may want to wait for sql2008.... (This may run counter to your "...feel it's...
Ok- that has to be the answer (and explanation for the deadlock in the first place): There's a FK in partner referencing the PK in party (note 3rd...
That's the reason for my OP! If these locks are not in conflict then WHY did SQL detect a deadlock and choose a deadlock victim?
I've started tracking deadlocks on a newly implemented system (sql2005 sp2) and have a question. I thought I generally understood the logged...
Separate names with a comma.
