Viewing 15 posts - 15,166 through 15,180 (of 22,219 total)
Good advice. Take a look at the SQL Server Dynamic Management Views. They're an amazing window into what's going on inside SQL Server. Most of the monitoring tools leverage them...
"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:09 pm
You're entering into a pretty crowded field. There are tons & tons of monitoring tools out there. The only advice I can give you is that you need a hook,...
"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 1:29 pm
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
Viewing 15 posts - 15,166 through 15,180 (of 22,219 total)