Viewing 15 posts - 7,591 through 7,605 (of 22,226 total)
You can set up a virtual network that allows you to treat the VMs as if they were part of your on-premises servers. Then, you have lots of choices. 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 15, 2014 at 6:11 am
chrisn-585491 (8/11/2014)
Because 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
August 15, 2014 at 6:05 am
Why are you worried about updating the statistics? They're going to get updated naturally by the internals process of SQL Server anyway. Some of those updates may be sampled, 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
August 15, 2014 at 6:01 am
It's vendor specific whether or not they actually support database restores as part of their snapshot mechanism. Some do, some don't. A test restore is the best mechanism to validate...
"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 15, 2014 at 5:57 am
After you backup the system databases, get everything into source control. All the jobs can be scripted out, put that into source control. Your databases and their code & structures...
"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 15, 2014 at 5:55 am
Multiple requests seems nuts. In fact, I prefer to let the developers just develop. You may think you need a table that looks like X, get part way into 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
August 15, 2014 at 5:53 am
SQLRNNR (8/14/2014)
Luis Cazares (8/14/2014)
Grant Fritchey (8/14/2014)
Evil Kraig F (8/14/2014)
djj (8/14/2014)
ChrisM@Work (8/14/2014)
remember '76/'77
Wish I could remember what last year was like, I remember some nice days for '77 as I...
"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 14, 2014 at 3:40 pm
Evil Kraig F (8/14/2014)
djj (8/14/2014)
ChrisM@Work (8/14/2014)
remember '76/'77
Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture of me...
"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 14, 2014 at 12:00 pm
Yes, you can use the SQL Agent Alerts. Here's an introduction to them in the Books Online.
"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 14, 2014 at 10:46 am
Or, you'll need to uninstall and then reinstall SQL Server. Not my preferred approach, but one that will work.
Be sure you have good backups in place before you do any...
"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 14, 2014 at 9:20 am
mqbk (8/13/2014)
It turned out that the configuration for the NIC teaming was the issue along with errors in the switches. Once they were corrected, the timeouts went away.
Thanks for 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
August 14, 2014 at 8:42 am
Interesting stuff. Thanks for posting the follow up. Clearing the cache as a mechanism for dealing with bad parameter sniffing is somewhat problematic. You might want to look to plan...
"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 8, 2014 at 4:52 am
GilaMonster (8/5/2014)
Grant Fritchey (8/5/2014)
sqldriver (8/5/2014)
Grant Fritchey (8/5/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
August 5, 2014 at 5:34 pm
smtzac (8/5/2014)
TDE is enabled, do you think page compression will work?
Possibly. If I remember correctly (and we're going off my memory, so Katy bar the door), they compress before they...
"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 5, 2014 at 5:33 pm
Eirikur Eiriksson (8/5/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
August 5, 2014 at 5:31 pm
Viewing 15 posts - 7,591 through 7,605 (of 22,226 total)