Viewing 15 posts - 18,661 through 18,675 (of 22,226 total)
Paul just twittered that he was finishing the first draft of the 2008 version.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 11:47 am
Bob Hovious (1/21/2009)
I don't have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 11:21 am
Bob Hovious (1/21/2009)
I don't have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 11:19 am
Lynn Pettis (1/21/2009)
GSquared (1/21/2009)
What's up with the grapes table that only has a priority column? What does that have to do...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 11:18 am
Lynn Pettis (1/21/2009)
Grant Fritchey (1/21/2009)
http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx
No answers to the questions, no further interaction at all. I wouldn't be surprised to see...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 11:06 am
Michael Earl (1/21/2009)
Lynn Pettis (1/21/2009)
Grant Fritchey (1/21/2009)
http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx
No answers to the questions, no further interaction at all. I wouldn't be surprised...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 11:03 am
Matthew Zuberko (1/21/2009)
I have a view which includes joins to a single table view and a single table subquery, and UDF is called in the column list. The query runs...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 10:52 am
This is the second time this exact question has been posted:
http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx
No answers to the questions, no further interaction at all. I wouldn't be surprised to see it again in two...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 10:35 am
First, a question, you're moving 1.8 million rows out of the EventInformation_rob table. How many rows total are in the table? If you're moving most of the table, you're going...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 8:11 am
I'd suggest getting a copy of the book "Database Administration" by Craig Mullins. It's not technical and it doesn't focus on SQL Server at all. Instead it talks about the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 7:54 am
Kent Waldrop (1/21/2009)
The same question was posted here:http://www.sqlservercentral.com/Forums/Topic639228-145-1.aspx
You responded to that post also.
I thought I remembered seeing that before.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 7:41 am
george sibbald (1/21/2009)
Grant Fritchey (1/21/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 7:06 am
True.
And one other thing I just thought of, your clustered index is a part of the covering index even though you can't see it.
Assume that ID is the clustered index....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 7:05 am
Statistics are enough the same between the versions that you don't really need to worry about them too much.
The only way to create a covering index in 2000 was to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 6:41 am
The overwhelming majority of our production systems are 2000. We're starting an initiative this year to get them upgraded to 2008 over the next two years because, in 2010, extended...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2009 at 6:30 am
Viewing 15 posts - 18,661 through 18,675 (of 22,226 total)