Viewing 15 posts - 13,126 through 13,140 (of 22,219 total)
In terms of queries, the most important thing would be to write them well to begin with. I'd take a look at Itzik Ben-Gan's TSQL Querying book. There are some...
"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 28, 2011 at 1:15 pm
It's not a "known problem" it's a particular behavior. I'm not sure why some of the logs thought that there wasn't a full backup, but it's a switch that gets...
"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 28, 2011 at 6:37 am
dixon_dwayne (2/27/2011)
DNA_DBA (2/26/2011)
"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 27, 2011 at 5:43 am
wildfairy1 (2/27/2011)
"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 27, 2011 at 4:55 am
wildfairy1 (2/26/2011)
I am not sure if I have understand your statement fully here when you mention
"You should make sure that you're doing that as a batch, not as a...
"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 26, 2011 at 4:41 am
If you really are on an unreliable network, then most of the really stable and fast DR scenarios are not going to work too well for you. Log shipping might...
"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 25, 2011 at 8:33 am
I'm not familiar with Site Scope, but it looks like it only monitors the request end, not SQL Server itself. If the tool you're using is the same, then 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 25, 2011 at 8:25 am
Way too much unkown here. OK, so performance slows... in what way? Are queries running slower or are you getting fewer queries run? Have you looked at the wait statistics...
"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 25, 2011 at 5:46 am
I couldn't possibly tell you what to do without knowing what errors are involved. Check the SQL Server error logs. In Management Studio, expand the management box and it's under...
"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 25, 2011 at 5:40 am
That is the default functionality. I'm seeing it too.
Why not just type 'SELECT TOP (1000) * FROM MyTable' and then you can take direct control over everything that happens?
For a...
"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, 2011 at 3:10 pm
Are you 100% sure the slow part of the process is the select statement? Also, if it's just a straight select, no joins, no where clause, then you're dependent 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
February 24, 2011 at 3:02 pm
Actually the Red Gate book is on execution plans. The one on performance tuning is from Apress. Both are linked below.
"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, 2011 at 2:59 pm
wildfairy1 (2/24/2011)
"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, 2011 at 1:41 pm
Ian Scarlett (2/24/2011)
If I was in the market for one of those, I wouldn't buy from a company that does that sort...
"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, 2011 at 8:27 am
I strongly recommend you take a look at the Red Gate Team Development[/url] book. It's free and it covers a lot of your questions in great detail.
"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, 2011 at 8:24 am
Viewing 15 posts - 13,126 through 13,140 (of 22,219 total)