Viewing 15 posts - 13,696 through 13,710 (of 22,219 total)
To my knowledge, you're in trouble when it comes to straight TSQL. There is no way to do this.
You could look at writing a CLR procedure to do it, 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
January 6, 2011 at 8:36 am
Junglee_George (1/6/2011)
AlsoThe primary difference between both is that Exec statement is Unparameterised whereas sp_executeSql is Parameterised.
I'd change that statement to "sp_executesql can be parameterized" because queries run through sp_executesql...
"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 6, 2011 at 8:34 am
Henrico Bekker (1/6/2011)
deepikamm (1/6/2011)
what is the major difference between EXEC and sp_executesql?they are the same....
Dave explains is very nicely...
EXEC and EXECUTE are the same, but the question was between EXEC...
"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 6, 2011 at 8:30 am
the only way I know that you could do this is when your databases are running on a SAN. Then, you can use some of the transaction aware SAN utilities...
"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 6, 2011 at 8:17 am
Yep, I'm recommending against it. I'm just using a lot of hedge words because you can make it work, but you probably shouldn't.
"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 6, 2011 at 8:03 am
Just remember this, if you put all 11 columns into the clustered index, they are stored in every non-clustered index too. Also, if they're the primary key, they're in every...
"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 6, 2011 at 7:36 am
I have an account. I do nothing with it except accept all the friend requests that come in. That and delete mafia and farm requests (you people need to get...
"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:25 pm
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
Viewing 15 posts - 13,696 through 13,710 (of 22,219 total)