Viewing 15 posts - 6,691 through 6,705 (of 22,221 total)
Jeff Moden (2/24/2015)
Brandie Tarvin (2/24/2015)
Jeff Moden (2/24/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 24, 2015 at 12:46 pm
Depending on what you have for affinity, that may be limiting the number of processors being used and will give you a baseline to start from.
"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 24, 2015 at 5:41 am
The one technology built into SQL Server would be Merge Replication, but it's a nightmare to maintain and it requires every table taking part to be modified (you have to...
"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 24, 2015 at 4:34 am
Yeah, new full backup. Any time you switch between simple and full you need to take a new full backup immediately after.
"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 24, 2015 at 4:29 am
I wouldn't say that's a precise art. You do know how much you're utilizing your current system. You can extrapolate somewhat from there. But, you also need to look at...
"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 24, 2015 at 4:26 am
Here's one of the simplest[/url] most straight forward formula's for setting your memory. Follow the recommendations here and you'll be fine in almost all situations.
"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 23, 2015 at 4:45 pm
Glad the book is helpful. You know where to go with questions.
I'm not aware of an explicit statement regarding forward compability, no. I know I've run into issues all 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 23, 2015 at 11:21 am
It really depends on what you're trying to do. If you're trying to identify long running queries, you'll probably get most of them using the approach outlined. If you're 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
February 23, 2015 at 10:32 am
For the most part, tooling from Microsoft is backwards compatible, but not forwards compatible. Meaning, SQL Server Management Studio for SQL Server 2012 will connect readily to SQL Server 2008....
"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 23, 2015 at 10:20 am
Just remember that those queries are completely cache dependent. If anything has aged out of cache or queries that don't go into the cache (such as queries with RECOMPILE hints),...
"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 23, 2015 at 10:18 am
It's generally a good idea to have SQL Server run on a machine by itself and not share the server with other processes. SQL Server only consuming 85% sounds like...
"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 23, 2015 at 4:25 am
Bouke Bruinsma (2/23/2015)
GilaMonster (2/23/2015)
Bouke Bruinsma (2/22/2015)
First of all, make sure you create full backups asap. Big tranlogs are usually a sign of absence of full backups altogether.
Absolutely not. 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 23, 2015 at 4:14 am
Run DBCC CHECKDB.
The output will tell you what is corrupted. If you're lucky, it's a nonclustered index. You can drop it and recreate it and walk away a winner. 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 22, 2015 at 6:05 am
You can only update multiple rows in a single statement if they have matching criteria. For example, there's a ShipByDate and they all have the same value, then the WHERE...
"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 22, 2015 at 6:03 am
"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 21, 2015 at 8:25 am
Viewing 15 posts - 6,691 through 6,705 (of 22,221 total)