Viewing 15 posts - 20,266 through 20,280 (of 22,224 total)
I've never tried doing it like that before. I generally just schedule perfmon to collect counters during the anticipated runtime of a process like that. Also collect Profiler data and...
"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
June 3, 2008 at 5:51 am
Definately post the execution plans.
Even without them, changing the collation on the fly is likely to prevent the use of an index on the column. IN clauses act as cursors,...
"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
June 3, 2008 at 5:41 am
I would recommend starting with Itzik Ben-Gan's "Inside SQL Server 2005: T-SQL Querying." It's one of the best books on TSQL out there and I can't recommend it enough. I...
"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
June 3, 2008 at 5:27 am
I'm not sure. When I drop the database, the files go away too. Did you detach instead of drop the database?
"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
June 3, 2008 at 5:24 am
Whoa!
I've definately seen variation, but nothing that extreme. Yeah, I'd love to see those examples. I'm just starting an article on how to break down complex queries. I may have...
"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
June 2, 2008 at 11:37 am
It's really two different queries. I'd split them into two procedures, even if you call them from this single procedure, have it call the other two procedures depending on the...
"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
June 2, 2008 at 11:33 am
And...
FROM @Datalink.Query(1).Name@ DQ1,
@Datalink.Query(2).Name@ DQ2
LEFT JOIN DQ1 on SC_NAMES.SC_CODE = DQ1.SrcCode
You've got a couple of other problems. You're mixing a variable in for the schema owner? You can't 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
June 2, 2008 at 11:25 am
SC_NAMES is not a table in the FROM list.
"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
June 2, 2008 at 11:20 am
I still land back at using one of the third party tools. They're very effective. I know the Red Gate tool can be run from the command line so 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
June 2, 2008 at 9:07 am
Sorry, I said ad hoc when I meant dynamic. I didn't mean to be unclear.
Seriously though, you'd be better off with dynamic queries running on each database individually rather than...
"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
June 2, 2008 at 9:03 am
To all intents & purposes... Jinx!
"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
June 2, 2008 at 8:46 am
If you're going with ad hoc queries, save yourself the headaches and just write the code directly against each database. The performance won't be any worse and the development and...
"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
June 2, 2008 at 8:44 am
I'm not entirely sure I understand the question, but I'll take a shot.
You can export the entire schema to a single SQL file. Then you can use a third party...
"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
June 2, 2008 at 8:40 am
Yeah, I've seen SINGLE_USER fail too. There is a lag, however tiny, between that GO statement and the next statement in the batch. It only takes one connection to muck...
"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
June 2, 2008 at 8:37 am
mailsar (6/2/2008)
I am in the process of creating few tables and indexes. I am creating a vendor table and a service table. The Vendor and service...
"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
June 2, 2008 at 8:27 am
Viewing 15 posts - 20,266 through 20,280 (of 22,224 total)