Viewing 15 posts - 13,081 through 13,095 (of 22,227 total)
ksharpe (3/9/2011)
Here is the query:
SELECT [ProductID]
...
"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
March 9, 2011 at 12:11 pm
Sounds like you're not table qualifying the columns in the WHERE clause. Add the table and you should be fine.
"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
March 9, 2011 at 11:01 am
tgarland (3/7/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
March 9, 2011 at 10:55 am
Which? Three different things were mentioned.
"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
March 9, 2011 at 10:51 am
sqldba_icon (3/9/2011)
Grant Fritchey (3/9/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
March 9, 2011 at 10:50 am
So for each column in a 200 column table, you need to get a row from a different table in order to understand what that column actually is? Yikes. That...
"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
March 9, 2011 at 8:39 am
You're in a great position for a side-by-side upgrade. It's the better approach for upgrading anyway. Install the 2008 server, restore the the 2000 databases to it and then do...
"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
March 9, 2011 at 8:23 am
Based on what you wrote (and yes, I read it too), you have two options. First, set up a serveri-side trace as Gail has already suggested. Second, you can try...
"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
March 9, 2011 at 8:21 am
We've been using it quite a while with no issues. I suppose it's remotely possible that you could mixed data if you had a lot of transactions all trying to...
"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
March 9, 2011 at 8:12 am
In general, the way you can tell something is parameter sniffing is not simply if it runs faster or slower, that could be contention or any number of other things....
"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
March 9, 2011 at 8:05 am
BeginnerBug (3/9/2011)
Thanks fritchey.....
It's Grant, and you're welcome.
"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
March 9, 2011 at 6:52 am
Beyond validating connectivity and running the DBCC checks, no, there's nothing to do at the database level.
As far as the server goes, you're going to want to migrate all your...
"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
March 8, 2011 at 9:17 am
OLDCHAPPY (3/8/2011)
for the 3rd time...IT WON'T ACCEPT DECIMAL VALUES. :crazy:and 95% is simply an example value. it's just an easy value to make the server hit to test alerts.
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
March 8, 2011 at 9:14 am
OLDCHAPPY (3/8/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
March 8, 2011 at 8:45 am
Basically you just asked it to create a new execution plan. If this is a seldom called, complex, long-running query, paying the cost for compiling a new plan, especially since...
"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
March 8, 2011 at 8:22 am
Viewing 15 posts - 13,081 through 13,095 (of 22,227 total)