Viewing 15 posts - 6,736 through 6,750 (of 22,229 total)
The single best validation is to use the backup to restore a database. But, the second best validation is to use RESTORE... VERIFY_ONLY. I wrote an article about backup validation[/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
February 19, 2015 at 4:58 am
You can get a ballpark guess as to the status of a backup by looking at sys.dm_exec_requests. It shows a percentage complete for backups. Now, it's not terribly accurate, but...
"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 19, 2015 at 4:55 am
We had different servers with different Service Level Agreements. When the backups on the highest SLA failed, it was an oncall situation because we had to have a 10 minute...
"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 19, 2015 at 4:53 am
You either have to make the connection between the two using a piece of software, or, you need to export to a shared resource and then import from that shared...
"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 19, 2015 at 4:51 am
Yep. Apply the latest service pack. It also applies to Express. It's the server properties that tell you what version the server is on and that's what counts for 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 19, 2015 at 4:49 am
shane.green 1227 (2/19/2015)
"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 19, 2015 at 4:23 am
Lynn Pettis (2/18/2015)
The party is starting at the TitD. Be careful where you walk, you don't want to step on the single digit midget!
Yeah, but now you even start...
"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 19, 2015 at 4:19 am
Lynn Pettis (2/18/2015)
... Mark one off, 9 days on the calendar to go. 9 days on the calendar to go, 9 days to go, ...
SINGLE DIGITS! WHOOOOOP!!
"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 19, 2015 at 4:17 am
Yeah, if you're filtering, you need a clustered index. That's pretty standard. And, it should be the most common access path to the data. Where possible you should also look...
"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 18, 2015 at 2:46 pm
Scott already said. You have two processors with 10 cores each. One has NUMA enabled and one does not. Two is the safest bet. I'm not a hardware expert, so...
"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 18, 2015 at 2:44 pm
Local variables versus hard coded values versus parameters, you could be seeing parameter sniffing in action. The hard coded values will take an accurate measure of the statistics. The parameters...
"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 18, 2015 at 2:39 pm
Maybe I missed the .sql on the second one. It had the standard name for a window. My bad.
"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 18, 2015 at 2:36 pm
Is it possible it's coming in as read only? I work with various source control systems all the time and I'm not seeing a similar issue.
One difference between the two...
"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 18, 2015 at 11:36 am
Compile time for the query and time to load everything into memory. Those are pretty standard costs that affect many queries the first time they're run.
"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 18, 2015 at 11:24 am
On a side note, make sure you change the Cost Threshold for Parallelism to something other than the default. That's going to affect how your processors get used in 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
February 18, 2015 at 11:21 am
Viewing 15 posts - 6,736 through 6,750 (of 22,229 total)