Viewing 15 posts - 13,696 through 13,710 (of 22,224 total)
I am a huge fan of upping the cost threshold for parallelism. I'd set it higher, a lot higher, than the default for most OLTP systems I manage. 35 is...
"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 7, 2011 at 7:51 am
Obviously, I want my cake and I want to eat it too (and I'll have as much of yours as I can)... or at least that's how most businesses would...
"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 7, 2011 at 5:48 am
Indexes can make sort operations run faster. It does depend on what is being sorted, how many rows, what the rest of the query looks like etc. Try it. 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
January 6, 2011 at 12:34 pm
r.pe (1/6/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 6, 2011 at 8:55 am
I don't completely understand. You're saying that if you ran a query against sys.foreign_keys and sys.foreign_key_columns that you would not see data returned if there are duplicate keys? That's 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
January 6, 2011 at 8:39 am
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
Viewing 15 posts - 13,696 through 13,710 (of 22,224 total)