Viewing 15 posts - 11,011 through 11,025 (of 22,219 total)
manoj_lanser (4/25/2012)
I don't want that insert generate script.I want to see which insert query is used in inserting data into the table.
Totally different.
If the inserts have already happened, the only...
"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
April 25, 2012 at 5:38 am
Agree with what everyone said regarding the clustered index on the ID column. I don't think it's the way to go.
As far as getting index scans goes, it really comes...
"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
April 25, 2012 at 5:16 am
You can get a generated query. Within SQL Server Management Studio (SSMS) right click on the table and select "Script Table As" from the context menu. You'll see a second...
"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
April 25, 2012 at 5:08 am
You'll get an error. Whether or not it stops the process, I can't say, not knowing what kind of code you have, error trapping, etc.
I would suggest that it's more...
"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
April 25, 2012 at 5:04 am
Since that data type isn't supported in 2005, you need to get all the data to filter first on the 2008 server. Have you tried running the same query using...
"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
April 25, 2012 at 5:01 am
I would not call the table 'interim." That is a term that describes the function of the table. The table is for the many-to-many join. Many people can have many...
"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
April 25, 2012 at 4:22 am
GilaMonster (4/24/2012)
Evil Kraig F (4/24/2012)
Heh, you guys reminded me that I want to order up the final books in the Dresden series and finish that... 🙂
Final? <sob>
If it finishes where...
"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
April 24, 2012 at 7:18 pm
GilaMonster (4/24/2012)
Grant Fritchey (4/24/2012)
"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
April 24, 2012 at 7:17 pm
GilaMonster (4/24/2012)
The Dixie Flatline (4/24/2012)
I just finished reading "Shadows In Flight", if you've ever read Orson Scott Card and like Bean better than Ender. Recommended.
Intriguing... I loved...
"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
April 24, 2012 at 7:16 pm
GilaMonster (4/24/2012)
Grant, you mentioned the other day that you'd finished the book "Temporary Duty" This one http://www.amazon.com/Temporary-Duty-ebook/dp/B00531CPHC/? Good? Recommended?
Looking for some good sci-fi again (space ships, interstellar travel, etc)....
"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
April 24, 2012 at 4:06 pm
GilaMonster (4/24/2012)
Grant, you mentioned the other day that you'd finished the book "Temporary Duty" This one http://www.amazon.com/Temporary-Duty-ebook/dp/B00531CPHC/? Good? Recommended?
Looking for some good sci-fi again (space ships, interstellar travel, etc)....
"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
April 24, 2012 at 4:04 pm
Jack Corbett (4/24/2012)
Grant Fritchey (4/24/2012)
Kiara (4/24/2012)
Lynn Pettis (4/24/2012)
The Dixie Flatline (4/24/2012)
Just....walk...
away....
Nope, too much fun watching now. I can even answer his question on why he keeps getting...
"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
April 24, 2012 at 3:02 pm
Kiara (4/24/2012)
Lynn Pettis (4/24/2012)
The Dixie Flatline (4/24/2012)
Just....walk...
away....
Nope, too much fun watching now. I can even answer his question on why he keeps getting the same value for @qtd on...
"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
April 24, 2012 at 10:55 am
Only one comment. Both plans show the reason for early termination within the optimizer as Timeout. That means that neither plan can be trusted. Did the optimizer come up with...
"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
April 24, 2012 at 10:50 am
My threshold on cursors is simple, "As close to zero as possible"
Yeah, I've used cursors for maintenance scripts because you can't do batch backups or batch statistics updates (well, I...
"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
April 24, 2012 at 10:30 am
Viewing 15 posts - 11,011 through 11,025 (of 22,219 total)