Viewing 15 posts - 6,676 through 6,690 (of 22,211 total)
Brandie Tarvin (2/25/2015)
I...
February 25, 2015 at 5:33 am
Take a look at the wait statistics on the server to see what is causing things to run slow. Or, better still, capture the waits prior to a backup and...
February 24, 2015 at 12:58 pm
If you're running a SELECT prior to the UPDATE, you might want to put an UPDLOCK hint on the SELECT. That way you take out the lock you want when...
February 24, 2015 at 12:56 pm
I'd only capture the deadlock graph event to minimize the impact of trace. Better still, why use trace? You're on 2012. Use extended events. It has a smaller footprint and...
February 24, 2015 at 12:53 pm
Jeff Moden (2/24/2015)
February 24, 2015 at 12:47 pm
Jeff Moden (2/24/2015)
Brandie Tarvin (2/24/2015)
Jeff Moden (2/24/2015)
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.
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...
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.
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...
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.
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...
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...
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....
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),...
February 23, 2015 at 10:18 am
Viewing 15 posts - 6,676 through 6,690 (of 22,211 total)