Viewing 15 posts - 13,336 through 13,350 (of 22,224 total)
It has to do with how the GUI collects data. Here's a good article on it.
"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
February 9, 2011 at 7:26 am
kasaranenikiran-725528 (2/9/2011)
Thnanks for all the Info. I did a reload of the table from other source.Regards
Kay
Excellent. I'm glad you were able to recover it.
If this 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
February 9, 2011 at 6:52 am
SKYBVI (2/9/2011)
but wat about the backups being done in night...
how to know who,when and...
"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
February 9, 2011 at 6:48 am
Gianluca Sartori (2/9/2011)
Grant Fritchey (2/9/2011)
"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
February 9, 2011 at 6:45 am
I suppose on pretty slow systems or off hours that makes sense to try. But on a reasonably heavily used system... you better be very quick with the keyboard.
"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
February 9, 2011 at 6:44 am
Kwisatz78 (2/9/2011)
Ok great thanks Grant I will check it out - btw I read your book on Execution Plans very informative 🙂
Thank you! It's good to know it's been helpful.
"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
February 9, 2011 at 6:43 am
It really depends on the business. There are places where nosql is going to, rightly, kick out OLTP systems. There are places where nosql does not belong. Just as 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
February 9, 2011 at 6:37 am
You're unlikely to get someone to do your work for you for free. Instead, you shoul focus your efforts on the things that people have already suggested. Learn about entity...
"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
February 9, 2011 at 6:25 am
I'm fairly certain this was added to the deprecation list in 2005. That means that the very next release of SQL Server will remove it (assuming 2005, 2008, 2008 R2...
"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
February 9, 2011 at 6:19 am
Nope.
It's gone.
You really should reexamine your backup strategies. Once every four months, even in a development environment, is way too long. If it's a production environment, it means that 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
February 9, 2011 at 6:12 am
How are you monitoring the process? If you use sys.dm_exec_requests you can see what the process is waiting on (as well as if other processes are waiting on it). If...
"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
February 9, 2011 at 6:05 am
mohammed moinudheen (2/9/2011)
First let the backup command run to take the backup on server location
and...
"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
February 9, 2011 at 6:00 am
If you know which procedure is causing problems, get that query's plan handle and use DBCC FREEPROCCACHE(plan_handle). That way you're not nuking the cache, but going for surgical strikes.
"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
February 9, 2011 at 5:58 am
There isn't a way to write a single query that will gather all the information needed. Like the link to Brent's site shows, you're going to, at a minimum, hit...
"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
February 9, 2011 at 5:56 am
parissa_bakhshi (2/8/2011)
You mean the book which is published by APRESS?written by Grant Fritchey and Sajal Dam?
Yep. My book covers a pretty hefty chunk of what you're asking about.
"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
February 9, 2011 at 4:49 am
Viewing 15 posts - 13,336 through 13,350 (of 22,224 total)