Viewing 15 posts - 21,466 through 21,480 (of 22,219 total)
Or, I didn't think that through all the way and I'm wrong.
"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
December 3, 2007 at 10:23 am
If you have a primary key constraint defined as nonclustered, you already have an index on that column, so no worries there.
Yes, you don't have to include 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
December 3, 2007 at 9:49 am
It simply gives you an indication whether the error is informational, really important, fatal to a connection or fatal to the server. See the reference linked above for details.
"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
December 3, 2007 at 7:05 am
I went and read the original message. It's whining, pure and simple. I then read as many of the comments as I could stomach. It's kind of freaky how attached...
"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
November 30, 2007 at 9:01 am
The real problem is, I am a jerk. So I have to try to reduce the damage as much as possible. Emails are dangerous because, even a well crafted message...
"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
November 30, 2007 at 6:57 am
Sorry, I wasn't trying to upset anyone. I'm serious. I screw up all the time. The checks I can put in place to prevent my own errors will help those...
"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
November 30, 2007 at 6:54 am
In order to select FROM something, it needs to be a table valued object (table, view, function, temp table, table variable, OPENXML, XQuery). You can run a query against a...
"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
November 30, 2007 at 5:55 am
What about literally breaking the query up into smaller queries? You can call them all from a single wrapper query. You get more discrete, tuneable execution plans and you can...
"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
November 30, 2007 at 5:51 am
P Jones (11/30/2007)
There's considerable power in .NET datatables, datarelations, foreign keys,primary keys and constraints that can be all done programmatically.
Works like a charm too... until the first time a request...
"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
November 30, 2007 at 5:34 am
We're using this method and the same idea with whole databases in some of our datamarts. It works well to minimize down time. Best of all, if there is a...
"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
November 30, 2007 at 5:24 am
Having sent a few e-bombs in my time, I try hard to look at what I've written before I hit send if emotion is an attachment. Usually, if I'm completely...
"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
November 30, 2007 at 5:22 am
Oh, you'd have to drop the connections for the ms that the query takes, but, based on the process you've defined, you're slapping the users around at some point no...
"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
November 29, 2007 at 12:18 pm
How about sacrificing a little disk space;
Create the new table with a different name
load the new table
rename the old table
rename the new table.
drop the old table
The down time is completely...
"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
November 29, 2007 at 12:05 pm
Andras Belokosztolszki (11/29/2007)
Do read the instructions (after the install you will need to attach the extracted database files, but this is detailed...
"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
November 29, 2007 at 7:13 am
You can get Adventureworks through CodePlex.
The 2005 version is located here.
"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
November 29, 2007 at 7:12 am
Viewing 15 posts - 21,466 through 21,480 (of 22,219 total)