Viewing 15 posts - 15,181 through 15,195 (of 22,232 total)
crookj (5/4/2010)
CirquedeSQLeil (5/4/2010)
I think that helps to prove that things really are not random.It is the butterfly effect. (From Jurassic park I)
Joe
Jurassic Park? Ah you young geeks. It predates Jurassic...
"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
May 4, 2010 at 12:53 pm
A CTE is just a part of the query that needs it. As a matter of fact, a CTE must be consumed by the very next statement and can't be...
"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
May 4, 2010 at 12:09 pm
Steve Jones - Editor (5/4/2010)
I ought to run some numbers on them, but it seems the Random Word has more replies than this thread on some days.
Don't say stuff like...
"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
May 4, 2010 at 12:02 pm
Sorry, but that's every day's random word.
Just insert as needed.
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
May 4, 2010 at 11:54 am
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
May 4, 2010 at 11:37 am
Paul White NZ (5/4/2010)
Awesome - a KB article on how to post questions to an online forum:
That is great, but since it's basically right in there with the documentation, we...
"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
May 4, 2010 at 11:11 am
izdede (5/4/2010)
Both my machine and 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
May 4, 2010 at 9:26 am
The problem is you can't count on the estimated costs within execution plans to make a determination whether or not they're performing well because those costs are based on an...
"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
May 4, 2010 at 9:24 am
I'm with Gianluca, again. If you created the proc without a schema owner, it may have been created under your login. If you then try to execute it without including...
"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
May 4, 2010 at 7:32 am
If you bring in a third party tool like Hyperbac, you can access individual tables for restore of data from a database, file, or filegroup backup. Other than that, 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
May 4, 2010 at 7:26 am
Sounds like you're reading Itzik Ben-Gan's book. Excellent resource.
Derived tables are not the same thing as tables. A derived table is a way to use a query construct, such as...
"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
May 4, 2010 at 6:26 am
Yeah, Red Gate's SQL Refactor can do that type of work for you. You would still want to test, test, test, to be sure it got things right.
"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
May 4, 2010 at 6:24 am
The whole idea of relational data storage is that there is something to relate one entity to another. No relation, no join. Something makes you think that 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
May 4, 2010 at 6:23 am
I agree with Dave, specifics on your system are hard to say without a lot more detail. However, I would be very careful about indexes 2 & 3 in that...
"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
May 4, 2010 at 6:15 am
Try RESTORE FILELISTONLY. I think that'll get you what you want.
"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
May 4, 2010 at 6:12 am
Viewing 15 posts - 15,181 through 15,195 (of 22,232 total)