Viewing 15 posts - 10,801 through 10,815 (of 22,224 total)
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
The compile parameters are stored with the plan because they help show how the plan was created. You also get the ANSI settings stored with the plan. Other than 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
June 7, 2012 at 5:55 am
Assuming you're going to use sys.dm_exec_query_stats and then sort by CPU, I/O or some combination, then you can combine that DMO with sys.dm_exec_query_plan and look for queries that do 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
June 7, 2012 at 5:50 am
Viewing 15 posts - 10,801 through 10,815 (of 22,224 total)