Viewing 15 posts - 20,716 through 20,730 (of 22,224 total)
Profiler output is to a text column, but if you're selecting from a text column in a TSQL Query, you might not be seeing all the data (there's a limit...
"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 7, 2008 at 1:24 pm
I did write a couple of articles on unit testing here at SQL Server Central. Two of them cover DBPro and one covers TSQLUnit. Do a search. There might be...
"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 7, 2008 at 10:46 am
Most people just insert a row of data into the database, run a select query or a delete query and declare it successful if it finishes without error. For myself,...
"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 7, 2008 at 9:22 am
You must be experiencing blocking or something else on the server. This query, as you have it defined, takes 1 ms to run on my laptop (not exactly a screaming...
"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 7, 2008 at 8:25 am
By the way, from what I can see, GetMatricule is going to force the query to function like a cursor, running this select statement for each row in the result...
"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 7, 2008 at 8:21 am
Please post the execution plan.
"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 7, 2008 at 8:19 am
Or without anything else, an execution plan will identify the worst bottlenecks. Can you post one?
"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 7, 2008 at 7:50 am
Many, many congratulations. Well earned and well deserved.
A Jaeger on me Kathi!
"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 7, 2008 at 5:48 am
No disagreement here. Now, we need to talk about this bitmap field. Shouldn't that simply be another table & foreign key?
"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 7, 2008 at 5:46 am
"Authentication failed" is a security error. Whatever login you're attempting to use doesn't have the correct access on the server to which you are linking.
"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 7, 2008 at 5:42 am
Interesting concept. It could prove useful. I've voted for it.
"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 7, 2008 at 5:38 am
Oopps. My bad.
ps: I'm just Committed (commitable, committing, whatever) not a HallofFamer.
😛
"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 4, 2008 at 11:29 am
But wait, does "niftier" mean you're a sequeler or one of them thar ess cue ell 'ers?
"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 4, 2008 at 9:45 am
Well, let's push it along a bit.
SEQUEL Server 2008 is nifty!
"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 4, 2008 at 9:28 am
Looks like the post has smileys in place of parenthesis, but yeah, the query is working fine once those are replaced.
"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 4, 2008 at 8:31 am
Viewing 15 posts - 20,716 through 20,730 (of 22,224 total)