Viewing 15 posts - 10,801 through 10,815 (of 22,226 total)
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
But if you're unsure, you can check the header information on the full backup and the log backup and compare the begin and end log sequence numbers (LSN). These will...
"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 7, 2012 at 12:17 pm
You can also take a look at the free Red Gate utility SQL Search[/url]. It'll hit all the databases at the same time.
"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 7, 2012 at 12:15 pm
jasona.work (6/7/2012)
If / when I go to the SQL in the City, it'll only be the second such event I've been too. I do (when...
"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 7, 2012 at 11:32 am
anthony.green (6/7/2012)
GSquared (6/7/2012)
anthony.green (6/7/2012)
GSquared (6/7/2012)
You might be better off on a per-processor license. 2012, if I understand the licensing correctly,...
"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 7, 2012 at 8:40 am
There's nothing in SQL Server that tracks who is making changes automatically. You have to set something up ahead of time. There are lots of ways to do that, so...
"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 7, 2012 at 8:20 am
I trust these guys, but you know what, don't listen to them. If you want answers on licensing, go to Microsoft. That's the single best source of information and 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
June 7, 2012 at 7:03 am
My boss is constantly at me to switch over to Mac. Resisted so far. That's all I can tell you.
As to the rest, get lots of memory & fast...
"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 7, 2012 at 6:08 am
Not parsing the entire query, but several issues immediately jump out at me. First, you're not using ANSI standard JOIN syntax:
...FROM TableA AS a
JOIN TableB AS b
ON a.ID = b.ID...
But...
"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 7, 2012 at 6:01 am
Viewing 15 posts - 10,801 through 10,815 (of 22,226 total)