Viewing 15 posts - 9,031 through 9,045 (of 22,224 total)
I've got a number of examples on how to "get latest" rows in this article on versioned data.[/url]
"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 21, 2014 at 7:43 am
Since you are completely on your own on this, again, I suggest getting a copy of my book. Links are down in my signature.
After you get backups in place... 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
January 21, 2014 at 7:40 am
praneethydba (1/21/2014)
Still in Recovery. I am Panic.
My company is running this database from past 8 years and no indexing, no Primary/clustered index, No jobs etc.
So I want to streamline all...
"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 21, 2014 at 7:09 am
Ed Wagner (1/21/2014)
Grant Fritchey (1/21/2014)
"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 21, 2014 at 7:04 am
Hey Ed, make sure you use FORMAT in addition to the INIT statement. INIT doesn't rewrite the header, so if you ever do modify the backup being done in some...
"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 21, 2014 at 6:23 am
Just use sp_msforeachdb. That's what it's for. But, if you really, really don't want to use it, set up a cursor to cycle through the databases (that's all that 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 21, 2014 at 5:52 am
Or use INIT and FORMAT with the backup command to make it always be a single file instead of a series of files stacked together.
"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 21, 2014 at 5:48 am
Since you're posting this in the 2008 forum, I'm going to assume you're on a 2008 or better server. You can look at they system_health extended event session. It's running...
"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 21, 2014 at 3:44 am
Please supply a bunch more detail, especially the code you wrote and what you expected it to do 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 21, 2014 at 3:39 am
A full backup includes the part of the transaction log that hasn't been marked as getting removed, so if you had a huge jump in the size of the log...
"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 21, 2014 at 3:38 am
Minnu (1/21/2014)
I agree with you, tuning the queries and indexes will help.but please give one clarity...
is there any possibility that db_datareader can block queries...
Yes.
"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 21, 2014 at 3:26 am
Or if the data is less than an extent in size (8 pages), then it won't fragment either. Generally you shouldn't even bother defragmenting an index until it's at least...
"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 20, 2014 at 3:23 pm
Same here. One database backup on an individual file. No devices. I have done log backups to a single file, but that's still a single file for each database, just...
"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 20, 2014 at 3:18 pm
You'd have to search each database on the server. You can look for the table name in the system view INFORMATION_SCHEMA.Tables.
Or, you could go to Red Gate Software and get...
"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 20, 2014 at 5:34 am
Using the sys.dm_exec_query_stats DMV, all you can do is what you've done. Take the average and split it up by execution count. If you want a precise measure, you'll need...
"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 20, 2014 at 5:32 am
Viewing 15 posts - 9,031 through 9,045 (of 22,224 total)