Viewing 15 posts - 11,356 through 11,370 (of 22,224 total)
Tech on Tap is a free event, single tracked on one topic, yesterday's was on Virtualization. There were three 90 minute sessions and time for networking and questions in between....
"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
January 29, 2012 at 7:47 am
Any other List members going to Tech on Tap today? It's shaping up to be an excellent event.
"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
January 28, 2012 at 5:34 am
Really? I thought saying Visual Studio and the compliance checks was a direct answer...
Anyway, SQL Cop is also worth a look. 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
January 24, 2012 at 1:51 pm
Yes, it covers all objects. Same with SQL Search.
I work for Red Gate.
If you're entering into a major redesign of the database where you're going to be making lots...
"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
January 22, 2012 at 5:22 am
But, on the question of "Too Many Tables to Join"? No, I don't think 10 is too many tables. I wouldn't even worry about "too many" until I was looking...
"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
January 22, 2012 at 5:18 am
Do you have auto-shrink turned on with any of your databases?
"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
January 22, 2012 at 5:14 am
You might get some information if you look at sys.dm_exec_requests. It will show you if the process is waiting on something or blocked by something. It may also show 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
January 22, 2012 at 5:13 am
Welsh Corgi (1/20/2012)
Grant Fritchey (1/20/2012)
It means it waiting on something. You need to figure out what it's waiting on.BTW, doesn't sound good.
Grant,
Thanks. What is weird is I executed the jobs...
"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
January 20, 2012 at 8:13 am
It means it waiting on something. You need to figure out what it's waiting on.
BTW, doesn't sound good.
"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
January 20, 2012 at 7:44 am
GilaMonster (1/20/2012)
Grant Fritchey (1/20/2012)
GilaMonster (1/20/2012)
Grant Fritchey (1/20/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
January 20, 2012 at 7:42 am
TIMESTAMP is now a synonym in 2012. Just saw that the other night.
Like Gus says, ROWVERSION is the replacement. It's basically the same thing.
"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
January 20, 2012 at 7:40 am
Ninja's_RGR'us (1/20/2012)
GilaMonster (1/20/2012)
Ninja's_RGR'us (1/20/2012)
I live far enough. Not worth to waste 4 days on this, but you on the other hand live much closer to her ;-).
Much closer? 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
January 20, 2012 at 7:28 am
GilaMonster (1/20/2012)
Grant Fritchey (1/20/2012)
When it finds that, it identifies the least costly query by it's estimated cost and chooses that as the victim and initiates a rollback.
Just one minor...
"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
January 20, 2012 at 7:27 am
Simha24 (1/20/2012)
So that we are planing to run every 6 hours.
When i issue DBCC Opentran() --...
"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
January 20, 2012 at 7:22 am
Ninja's_RGR'us (1/20/2012)
Grant Fritchey (1/20/2012)
Ninja's_RGR'us (1/20/2012)
Isn't it better to use 1222 rather than 1204??Oh god. I can't believe I typed that. Yes, 1222 is better. I edited the post. Yikes.
I was...
"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
January 20, 2012 at 6:12 am
Viewing 15 posts - 11,356 through 11,370 (of 22,224 total)