Viewing 15 posts - 39,616 through 39,630 (of 49,552 total)
brd123 (4/20/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 21, 2009 at 2:36 am
Bear in mind that the -1/2TB 'bug' only applies to log files. Data files with unrestricted growth do show a -1 there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 21, 2009 at 2:21 am
Except for the first one, all the others are far too small to even worry about fragmentation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 2:41 pm
Gianluca Sartori (4/20/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 2:35 pm
If you're running a profile trace from SQL profiler, it's the client application that's receiving the trace from SQL and writing it to a table. Hence if you close profiler,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 2:31 pm
Lynn Pettis (4/20/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 2:26 pm
Jack Corbett (4/20/2009)
Another note for the non-Twitterer's is that there have been 358 sessions submitted to PASS so far, deadline is Friday at Midnight, for about 80-90 slots available.
Eeep....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 10:31 am
brd123 (4/20/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 10:26 am
The generator problem was a series of small problems.
This was a bank of large generators that were designed to supply power to 6 office blocks (one of which was a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 9:02 am
Depends whether the index has been created with PAD_INDEX on or off. If it's on, the fill factor applies to the non-leaf levels as well. If it's off, the non-leaf...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 8:37 am
GSquared (4/20/2009)
"the server room has smoke coming out of it and the halon alarm just went off to warn people to get out of there"
Now that's one I haven't had...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 8:25 am
What position are you applying for?
Main advice I can give you is to relax, be honest and be willing to admit that you don't know something. Especially for a junior...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 7:43 am
brd123 (4/20/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 7:27 am
I think you've got a form of data corruption there. I'm not sure how to deal with that myself, not on SLQ 2000. I've pinged an expert on corruption, I'm...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 7:22 am
I'll be blunt (as usual)
The phrase 'dumps' usually refers to questions memorised from the exam and posted online in violation of the NDA on exams. If that's want you're asking...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 7:21 am
Viewing 15 posts - 39,616 through 39,630 (of 49,552 total)