Viewing 15 posts - 13,711 through 13,725 (of 22,227 total)
sqlbuddy123 (1/5/2011)
You can even go with Redgate's SQL Monitor. Redgate tools are also excellent and are much cheaper than Idera's.
Thank...
"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 5, 2011 at 12:07 pm
I'm with Gus. You follow every best practice you can, enforce them as tightly as possible, and then, when the boss says to throw them out the window because of...
"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 4, 2011 at 12:13 pm
Marco V (1/4/2011)
check the default trace for the alter statement it is located in youre log directory by default.
Excellent idea. That's very likely in the default trace.
"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 4, 2011 at 8:11 am
I'm not sure, but it has to be somewhere in the system or attaching to the system. There's no reason for it to just randomly set itself to single user.
"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 4, 2011 at 8:07 am
Brandie Tarvin (1/4/2011)
Dave Ballantyne (1/4/2011)
Brandie Tarvin (1/4/2011)
And I found out I wasn't following Dave either. Silly me.
Funnily enough , most people arent surprised to find out they are not following...
"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 4, 2011 at 7:14 am
GilaMonster (1/4/2011)
btw Grant, your SSC sig is still listing your old blog.
Great googly moogly, how many places did I post that silly thing.
Thanks.
Good news is, even if people are going...
"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 4, 2011 at 6:52 am
Brandie Tarvin (1/4/2011)
Grant Fritchey (1/4/2011)
Dave Ballantyne (1/4/2011)
Grant Fritchey (1/4/2011)
It really is like launching a nuclear strike, but if you're not getting satisfaction, I'd tweet about it.
Already did , maybe everyone...
"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 4, 2011 at 6:50 am
Dave Ballantyne (1/4/2011)
Grant Fritchey (1/4/2011)
It really is like launching a nuclear strike, but if you're not getting satisfaction, I'd tweet about it.
Already did , maybe everyone was in a holiday...
"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 4, 2011 at 6:30 am
Dave Ballantyne (1/4/2011)
Chris Morris-439714 (1/4/2011)
Craig Farrell (1/3/2011)
"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 4, 2011 at 5:59 am
ibzmiller (1/4/2011)
I can't see how to mark you as having answered my question. Do we do that on this...
"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 4, 2011 at 4:58 am
GilaMonster (1/4/2011)
/* Kinds: Sale / Purchase */
If it's 2 values (and nvarchar255 to boot), it's going to be...
"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 4, 2011 at 4:53 am
GilaMonster (1/4/2011)
Grant Fritchey (1/4/2011)
the PK is not being used to determine access to the table. That at least suggests you should be looking elsewhere for the PK.
Not the PK,...
"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 4, 2011 at 4:19 am
Notice how the leading edge of three of the indexes is the [Kind] column. That starts to look like a better candidate for your clustered index than the primary key...
"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 4, 2011 at 3:55 am
ibzmiller (1/4/2011)
Thanks for the replies. That's the sort of thing I was looking for. What I would like to know if though, you mentioned using the snapshot, from...
"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 4, 2011 at 3:40 am
kmaida (1/3/2011)
Sorry, I feel like a complete novice, but how do I check to see if there's an ALTER DATABASE statement being run on the db thru a job?Thanks!
You can...
"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 3, 2011 at 8:57 pm
Viewing 15 posts - 13,711 through 13,725 (of 22,227 total)