Viewing 15 posts - 6,721 through 6,735 (of 22,219 total)
I strongly suggest you start putting your database code into source control in the same way as you would manage your application code. If this code is "important" as 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
February 19, 2015 at 5:39 am
You're not using this in any other place in the query? I set up a test:
SELECT CASE cr.CountryRegionCode ---Mod # 2 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 5:35 am
I wouldn't say either is better either. From what I can tell I think I'd have the same issue with both. I think you're going to get a single plan...
"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 5:17 am
In addition to Gail's excellent articles, for even more detail, check out my book on query tuning in my signature below.
You might also look at the free book Troubleshooting for...
"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 5:11 am
Check your Configuration Manager to see if you have any config issues, aliases, something along those lines. Compare your Config Manager to the person who is successful to see 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 19, 2015 at 5:05 am
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
Viewing 15 posts - 6,721 through 6,735 (of 22,219 total)