Viewing 15 posts - 48,436 through 48,450 (of 49,552 total)
I bought a whole lot too. Close on $400 of books.
I'll be learning from this conference for months to come, especially once the DVD arrives. It was definitely worth...
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
September 27, 2007 at 3:10 pm
This may sound like a stupid question, but please humour me.
How do you know you're having performance issues?
Are queries slow? If so, all queries or some? All the time or...
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
September 27, 2007 at 3:04 pm
:blink: :blink: You're right. Wow. Certainly puts some perspective on things.
If it hadn't been for the layovers in London the conference would have been longer, but not by much.
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
September 27, 2007 at 2:53 pm
Neither do I usually. I found this when I was posting a bug report, of all ironies.
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
September 27, 2007 at 2:38 pm
How many rows are in the table now? How many will still be there after the delete? Are there any foreign keys on this table or referencing this table?
If the...
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
September 27, 2007 at 2:33 pm
Iterative delete is easy, and often necessary on large deletes. This is how I do it. Others may have their own preferences
DECLARE @Done BIT
SET @Done = 0
SET ROWCOUNT 1000 --...
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
September 27, 2007 at 2:22 pm
Run checkdb with the no_infomsgs option. That way all you'll see are any errors, not the detailed breakdown of how many rows are in how many pages of each table,...
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
September 27, 2007 at 2:05 pm
This one.
Initially there was one blank line above. I edited 3 times.
p.s. Thanks for the email header. I get to clear out my mail box on monday when I get...
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
September 27, 2007 at 1:56 pm
Ninja's_RGR'us (9/26/2007)
:hehe: only is Shouth Africa :P.
I resemble that remark! 😀 :hehe:
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
September 27, 2007 at 1:55 pm
Make the points visible somewhere else (front page) and change the formula so that contributing scripts or articles also counts (probably more than qotd answers and forum posts)
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
September 27, 2007 at 1:53 pm
Ninja's_RGR'us (9/27/2007)
How was the return trip from PASS ?
Long. :doze:
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
September 27, 2007 at 1:48 pm
The major groups are fine. The forums within them seem to be changing order every time I visit.
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
September 27, 2007 at 9:33 am
In the forums, posts only. Generally, but not always, high post count shows someone who spends time answering questions, hence contributing to the site.
It's not difficult to get the QotD...
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
September 27, 2007 at 9:17 am
Questions are still multiple choice, but they're based off a business case given, usually a couple pages worth. As a very rough, very simplified example. (the question may not have...
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
September 27, 2007 at 9:01 am
What do you want the result to look like?
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
September 27, 2007 at 7:20 am
Viewing 15 posts - 48,436 through 48,450 (of 49,552 total)