Viewing 15 posts - 9,091 through 9,105 (of 22,219 total)
Again, I'm with Gail. I couldn't even guess. It could be almost anything from bad parameter sniffing to problematic code to missing/incorrect indexes to one query moving a lot more...
"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 13, 2014 at 6:28 am
I've been using a 3rd party tool to do that for the last 15 years. Actually, I liked their tooling so much, I went to work for that company about...
"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 13, 2014 at 5:04 am
Yep. That's my understanding too. If you need to have a large number of developers using Microsoft tooling, I'd suggest contacting Microsoft directly and negotiate an MSDN license for your...
"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 13, 2014 at 4:58 am
Like Gail says, T-SQL is T-SQL. Dynamic T-SQL will prevent some levels of code reuse which can lead to increased CPU use as more and more queries have to go...
"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 13, 2014 at 4:57 am
If it's asking for a serial number, you've gone past the 14 day free trial. You can contact sales and request an extension. Otherwise, you'll need to purchase the software.
"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 13, 2014 at 4:53 am
No, nor I. Most of the stuff in the error log is pretty self-explanatory and not usually vague. But, if you are looking for a good getting started book on...
"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 12, 2014 at 8:48 am
I don't think there is a single right answer to this. I very much believe that you should NOT use the administrative accounts as owners of the databases or 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
January 12, 2014 at 8:42 am
GilaMonster (1/10/2014)
BWFC (1/10/2014)
There is a philosophical question, often kicked around our office, about what happens when two people who know everything have an argument.
I'm sure I've seen that on gaming...
"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 12, 2014 at 3:40 am
You have processes that are doing things that use tempdb such as sorts or index rebuilds or something else. You need to identify these processes, figure out how long it's...
"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 10, 2014 at 4:15 am
It's a tough problem to solve. There are two sets of tools that could help you out. Microsoft has a deployment tool called SQL Server Data Tools (SSDT). You can...
"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 10, 2014 at 4:07 am
Sure. You can use SQL Agent to call the command line utility of Data Compare. You can then have that output to a report, generate a script or even update...
"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 10, 2014 at 3:53 am
ChrisM@Work (1/10/2014)
Grant Fritchey (1/10/2014)
Jeff Moden (1/8/2014)
rodjkidd (1/8/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 10, 2014 at 2:56 am
Jeff Moden (1/8/2014)
rodjkidd (1/8/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 10, 2014 at 2:35 am
Just a data insert alone will not affect plan cache (it sure can affect the rest of the cache). But, the update in statistics can affect recompiles. Maybe that's what...
"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 8, 2014 at 4:25 am
You can't really fragment an index with modifying the data. Don't test stuff in production.
"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 8, 2014 at 2:05 am
Viewing 15 posts - 9,091 through 9,105 (of 22,219 total)