Viewing 15 posts - 11,101 through 11,115 (of 22,219 total)
SQL Packager is an option, but you could just build a batch command using SQLCMD.EXE. It won't be an executable, but a batch file will work the same way. Another...
"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
April 11, 2012 at 6:12 am
Hints are not what's needed. In fact, I'd drop the FAST(1000) hint to start with. That's going to generate a skewed execution plan if you're returning more than 1000 rows....
"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
April 11, 2012 at 6:07 am
sqlnaive (4/11/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
April 11, 2012 at 6:03 am
I haven't tried setting up an alert, but I have set up monitoring using some of the DMOs available. This Book Online entry lays out a bunch of the options.
"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
April 11, 2012 at 4:59 am
You down-graded from 2008 to 2005? You can't move the time column because they don't exist in 2005. You'll have to store it as a string, a varchar, or you'll...
"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
April 11, 2012 at 4:55 am
Too many guesses without seeing the actual code involved. In general, I don't recommend using a hint like RECOMPILE unless there's a driving reason for it. Do you know what...
"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
April 11, 2012 at 4:50 am
SQLRNNR (4/10/2012)
Grant Fritchey (4/10/2012)
Stefan Krzywicki (4/10/2012)
Jack Corbett (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/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
April 10, 2012 at 2:56 pm
Stefan Krzywicki (4/10/2012)
Jack Corbett (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/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
April 10, 2012 at 1:18 pm
mtassin (4/10/2012)
Not true... at least not from this example. The OP said that all 4 columns were nvarchar(20).
From the original bit of code I copied, it was a column...
"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
April 10, 2012 at 12:21 pm
marksquall (4/10/2012)
You two have mentioned something about cache. I have certain things to know abut this cache and I hope it 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
April 10, 2012 at 12:12 pm
First off, you are using sp_executesql, which is good, as I said. Because of this, you're not generating hundreds & thousands of variations on the query. However, we're still 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
April 10, 2012 at 9:05 am
Gianluca Sartori (4/10/2012)
Grant, your "Depends" answers made me curious.CLR tricks aside, how can you call a procedure inside a function?
Why can't we use CLR tricks? 😛
And I hope you 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
April 10, 2012 at 8:15 am
I'm not aware of a tool that's going to generate graphical reports on everything you have listed. You might take a look at some of the tools from SQL Sentry....
"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
April 10, 2012 at 8:08 am
mtassin (4/10/2012)
If you choose to use Dynamic SQL, then you need to be warey of injection.
Creating a dynamic SQL string by appending text...
"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
April 10, 2012 at 7:59 am
asranantha (4/9/2012)
2)can we call functionn into another function if yes plz give small...
"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
April 10, 2012 at 7:44 am
Viewing 15 posts - 11,101 through 11,115 (of 22,219 total)