Viewing 15 posts - 19,441 through 19,455 (of 22,219 total)
You need to modify the code page in your query window to appropriately display the data. I'm actually not entirely sure how to do 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
October 17, 2008 at 7:44 am
We built a similar system. I outline the design and our tests in this article [/url]at Simple-Talk. To summarize, we create a version table, to which all the other tables...
"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
October 17, 2008 at 6:21 am
Did you update all the statistics after the migration?
Generally, there are exceptions, I've found SQL Server 2005 to be a bit faster, after some adjustments. You may want to check...
"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
October 17, 2008 at 6:15 am
You should just go through and update all the statistics, everywhere. Statistics are pretty different from 7 to 2000 and even more so from 2000 to 2005.
You'll want 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
October 17, 2008 at 6:08 am
Nothing really. The N is meant for use with string constants, the way you used it. The CAST is meant to work with just about any structural object that you...
"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
October 17, 2008 at 6:02 am
Couldn't you ensure the distribution this way?
WHEN (DATEDIFF(DAY, [Date on Waiting List], GETDATE()) / 7) BETWEEN 4 AND 8
THEN 2
And why aren't you using WEEK (or ww or...
"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
October 17, 2008 at 6:00 am
There's no real way to know this. If the same database you have in production was on a machine, all by itself, with no users, it might take 1 minute...
"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
October 17, 2008 at 5:55 am
jaggity (10/16/2008)
"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
October 17, 2008 at 5:50 am
Do the execution plans change between the two?
I agree with Matt. It's probably parameter sniffing.
"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
October 17, 2008 at 5:46 am
The easiest way to do it is probably with a backup & restore.
However, if you're making lots of changes over time to the structure or the data, you may want...
"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
October 17, 2008 at 5:37 am
jonathanmreynolds (10/16/2008)
isql.exe -U SA -P XXXXXX -d DBNAME -S SERVERNAME -n -i vsm_his2he.sql -o log.txt
bcp DBNAME.dbo.hotel_expert_room_registry out out1.txt -f param.txt -S...
"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
October 17, 2008 at 5:35 am
You can use a PRINT command to put it out into the Messages window.
"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
October 16, 2008 at 11:59 am
If you do nothing else at all, I'd recommend bumping that up to something like 25 or 30. I've seen it set as high as 50 on servers that still...
"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
October 16, 2008 at 8:45 am
Since you've got parallelism on, what's the threshold set 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
October 16, 2008 at 8:34 am
I'd suggest checking the variable that's being executed as the query, @clk_fund_stmt (and the others). Make sure that's structured correctly. If you're getting nulls, it's originating there.
"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
October 16, 2008 at 5:39 am
Viewing 15 posts - 19,441 through 19,455 (of 22,219 total)