Viewing 15 posts - 11,431 through 11,445 (of 22,219 total)
Bex (1/12/2012)
Grant Fritchey (1/12/2012)
GilaMonster (1/12/2012)
Evil Kraig F (1/11/2012)
GilaMonster (1/11/2012)
Errrrr... Someone(s) want to tackle this? http://www.sqlservercentral.com/Forums/Topic1234441-61-1.aspxAlready responded. I'm waiting to see his answer before continuing.
I just had a look over...
"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 12, 2012 at 5:49 am
GilaMonster (1/12/2012)
Evil Kraig F (1/11/2012)
GilaMonster (1/11/2012)
Errrrr... Someone(s) want to tackle this? http://www.sqlservercentral.com/Forums/Topic1234441-61-1.aspxAlready responded. I'm waiting to see his answer before continuing.
I just had a look over his posting history,...
"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 12, 2012 at 4:46 am
Looking at the restore command itself, logically it makes sense. You're going to have to break down & issue print statements to validate that everything is working. Instead of trying...
"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 11, 2012 at 9:12 am
azdzn (1/11/2012)
Querying the plan cache will do the trick ! Good idea !Thanks a lot Grant and Gail.
Sure thing. Just remember, as I say in the article, direct queries against...
"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 11, 2012 at 8:19 am
Maybe you need to do:
SELECT * FROM schema.table
If the table is not in your default schema, it won't just show up automatically.
"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 11, 2012 at 8:17 am
Stefan Krzywicki (1/11/2012)
GilaMonster (1/10/2012)
mtillman-921105 (1/10/2012)
I guess I'm really the only nerd around here,You and me apparently. We'll go be hopeless somewhere...
You are not alone. I'm definitely a nerd.
Not me. I'm...
"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 11, 2012 at 7:35 am
Scans are only one indicator of poor performance and are actually not even always a good indicator. SQL Server will run faster using a scan instead of a seek 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
January 11, 2012 at 7:30 am
But you have a good backup you can go to and retrieve everything, right?
If not, why not?
"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 11, 2012 at 6:23 am
Except for what Gianluca has posted, you're in trouble. However, going forward, you might try getting a copy of this tool from Red Gate. It can help with exactly 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 11, 2012 at 6:22 am
And is it working for you?
"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 11, 2012 at 4:45 am
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
Viewing 15 posts - 11,431 through 11,445 (of 22,219 total)