Viewing 15 posts - 11,446 through 11,460 (of 22,224 total)
The thing is, you're assuming that your data has no rows below 2004. I'll bet it's not what you think it is. Logically those queries are not equivalent. Best thing...
"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 10, 2012 at 5:20 am
You're comparing where the Year is less than 2010 or where the Year equals 2004. There are five other year values possible in the first query than the second query....
"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 10, 2012 at 4:52 am
I'm not sure what procedures do for monitoring. they're a way of executing tSQL on the database. So in answer to your specific question, no, don't use procedures.
But in terms...
"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 10, 2012 at 4:47 am
Another vote for wordpress and a suggestion for a blog post. Write about backups. It's a sure fire winner and people can't possibly learn enough about backups.
"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 10, 2012 at 4:36 am
Also, check sqlsaturday.com for an event near you. This is another way to learn DBA skills, from the best, for free.
PS: Mr. Shaw there just ran an event in Colorado...
"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 10, 2012 at 4:35 am
And look at when it was created. You have that information in the sys.dm_exec_query_stats DMO.
"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 10, 2012 at 4:28 am
The cost of an execution plan is just an estimate based on how many CPU and I/O resources that the query optimizer estimates that query will use.
You can use this...
"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 10, 2012 at 4:27 am
azdzn (1/9/2012)
You will only know how many times it has been called since last...
"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 10, 2012 at 4:22 am
You can have the identity column increment up, or down, but not both at the same time. To have it increment to negative numbers, set the increment value as -1...
"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 10, 2012 at 4:18 am
And only run the shrink one time after dropping all the tables. If you run it multiple times you're going to be fragmenting your files a lot.
"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 10, 2012 at 4:12 am
Brandie Tarvin (1/9/2012)
I have this image in my head of me wearing a monocle and top hat while holding cane in one hand and a cuppa in the other.
Oh,...
"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 9, 2012 at 9:34 am
Roy Ernest (1/9/2012)
When I get time post some thing,...
"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 9, 2012 at 9:31 am
san43 (1/9/2012)
I am specifically looking for any document published by Microsoft regarding T-SQL standard coding guidelines or best-practices, so that I can suggest developers...
"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 9, 2012 at 8:31 am
Perry Whittle (1/4/2012)
Jeffrey Williams 3188 (1/4/2012)
Perry Whittle (1/4/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
January 9, 2012 at 5:45 am
WayneS (1/6/2012)
Steve Jones - SSC Editor (1/6/2012)
User posts
SQLRNNR ...
"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 7, 2012 at 5:56 am
Viewing 15 posts - 11,446 through 11,460 (of 22,224 total)