Viewing 15 posts - 10,786 through 10,800 (of 22,219 total)
When I present I blow the font up large and I change it to Lucida Sans. It seems to work well for most people. I don't use that normally (maybe...
"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
June 13, 2012 at 5:51 am
glamourth (6/13/2012)
I have used sys.dm_exec_query_stats and sys.sysprocesses to find long running queries particulary more than 60 minutes. But, as am not gud at sql scripting not able to join...
"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
June 13, 2012 at 4:32 am
Steve Turner - SQL Managed (6/12/2012)
"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
June 12, 2012 at 12:26 pm
Ah, missed that it was tempdb. Still, assuming my disks are going off, I'm running an extra backup. I may still run DBCC on the other databases 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
June 12, 2012 at 10:54 am
First thing you should do is run a set of full backups. Then save that somewhere on the side or, better still, off-site.
After that, you can try to identify 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
June 12, 2012 at 10:47 am
Windows Azure is just application hosting. It's not an entire OS. For that you'd want to look at Amazon or Google. Windows Azure is for applications and SQL Azure is...
"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
June 12, 2012 at 7:14 am
Just a suggestion, start rewriting all the code now. You might be able to limp along on one version with compatibility support, but that's extremely limiting and, in the long...
"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
June 12, 2012 at 7:13 am
I have not done this, but I've heard it's possible to set up a traditional HA cluster and then add that cluster to an Availability Group cluster. It's important 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
June 12, 2012 at 7:10 am
Because CHECKDB will place additional load on the system and can affect transactions, while you do not need down time, I would schedule it during off-peak periods. Even better, 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
June 12, 2012 at 6:22 am
I've started using the code snippet manager built into SQL Prompt. Not only does it make it easy to store the things, but I can put a quick key 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
June 12, 2012 at 6:17 am
Maybe you need to do a refresh of the Object Explorer?
"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
June 12, 2012 at 6:14 am
You might want to check out SQL Cop. I wrote a review of it here[/url].
"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
June 12, 2012 at 6:14 am
Try getting a look at the execution plan when it's running slow. Compare that to the execution plan when it's running fast. If they're different, that's a pretty good indication...
"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
June 12, 2012 at 6:12 am
Koen Verbeeck (6/12/2012)
Grant Fritchey (6/12/2012)
It's a great and wonderful piece of software, but there's nothing earth-shattering in this release.
Wow wow wow. Hold on!
SSIS has a working undo button 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
June 12, 2012 at 5:58 am
Grant Fritchey (6/5/2012)
"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
June 12, 2012 at 5:48 am
Viewing 15 posts - 10,786 through 10,800 (of 22,219 total)