Viewing 15 posts - 7,546 through 7,560 (of 22,226 total)
I freely admit to my bias, but yeah, I think you can get Visual Studio to work very well. You have to plan to put the pre/post deployment scripts 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
August 25, 2014 at 7:10 am
How long does it take to rebuild your indexes. You would at least want to get a log backup at the beginning and end of that process (no, I'm not...
"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
August 25, 2014 at 4:53 am
Might want to check the power settings on the server. That's been hitting a lot of people lately and it will certainly have some of the effects you're outlining here.
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
August 25, 2014 at 4:49 am
Replication is one option. Replication is a bit of a bear to maintain though. You could also look to log shipping, although that has some shortcomings too.
"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
August 22, 2014 at 4:11 pm
GilaMonster (8/22/2014)
Robert Frasca (8/22/2014)
That must be the Database Name that is filtered on by Profiler rather than the fully qualified database name referenced in the query.
That's exactly what it's doing....
"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
August 22, 2014 at 12:54 pm
Red Gate SQL Prompt will do that.
"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
August 22, 2014 at 9:54 am
I don't disagree with the other points, but I'm with you, if you're not using that index, it's a waste. You only get one clustered index. Rather than just arbitrarily...
"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
August 22, 2014 at 9:48 am
It's a little outdated, but I wrote the source control chapters on this book on Team Development. It covers some of what you're looking for. Also, my company, Red Gate...
"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
August 22, 2014 at 8:59 am
Do you have enforced referential constraints on the columns you're joining on? Does the data accurately map between the two tables, or is it possible that you're getting multiple matches...
"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
August 22, 2014 at 8:57 am
No, you can't insert data into a table without some locking being applied. That's all part of the ACID properties of a relational database. You can look at trying out...
"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
August 22, 2014 at 8:55 am
It sounds like bad parameter sniffing. What's likely happening is that a query is getting an execution plan that doesn't work well for most data sets, that's causing issues, 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
August 22, 2014 at 8:52 am
You can use the transaction log backups from log shipping in a recovery scenario.
"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
August 22, 2014 at 8:47 am
SQLRNNR (8/22/2014)
In other news, what does everybody think of the Mythbusters news from last night?
I hadn't heard, but now that I know... I'm bummed. They made the show really fun.
"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
August 22, 2014 at 8:16 am
GilaMonster (8/22/2014)
Robert Frasca (8/22/2014)
I have one filter to include my specific database name, i.e. LIKE 'DatabaseName'
There's the problem.
Take that filter out, the event will then show up and 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
August 22, 2014 at 8:06 am
You should absolutely see a command like:
SELECT * FROM HumanResources.vEmployee AS ve
within a server side trace if you're capturing SQL:BatchStarting. The only reason you wouldn't see that command is because...
"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
August 22, 2014 at 7:37 am
Viewing 15 posts - 7,546 through 7,560 (of 22,226 total)