Viewing 15 posts - 21,721 through 21,735 (of 22,220 total)
It is possible, but as Colin has noted, it's definitely not the right approach. If you were to try it, the trick would be to only use a single parameter,...
"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 9, 2007 at 6:55 am
What data type is the BadPasswordTime inside 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
October 9, 2007 at 6:40 am
What about using sqlcmd to control the execution & output of the script?
There are not TSQL commands that take control of Management Studio and its behavior.
"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 5, 2007 at 11:41 am
Please repost over in the 2000 forum to get 2000 specific help.
"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 5, 2007 at 11:39 am
Everyone's favorite answer: it depends. If you have an inline function that is returing a table value, it effectively works like a view and the query processor blows out 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
October 5, 2007 at 7:11 am
I'm not sure it's a secret, but I can click on the Object Explorer window, say on the "Tables" folder within a database and there 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
October 5, 2007 at 6:05 am
You got it? Cool. It's a neat little trick that I learned from a Microsoft Consultant. It's good to see other people find it useful too.
"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 4, 2007 at 12:00 pm
Yeah. I put it that way in case, like us, you have a compound PK.
"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 4, 2007 at 9:47 am
I'd stay away from table valued functions unless performance is completely not a concern.
The cross apply should only return a single value such that you'd get more than one row,...
"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 4, 2007 at 9:17 am
Hmmm. Not an easy one. I looked through the code, I generated the query. Everything looks ok, assuming the data types in the tables are as presented, with one possible...
"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 4, 2007 at 9:00 am
Sounds like a problem inside the code of the stored procedure. Can you post it?
Assuming a straight SELECT query, at no point should there be a conversion from anything 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 4, 2007 at 8:17 am
Oh, OK. Well it sounds similar to a problem we have
SELECT ...
FROM p
CROSS APPLY (SELECT TOP 1 ...
...
"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 4, 2007 at 8:06 am
Wouldn't the EndDate be a "+" 1 to make it a day larger than the EffectiveDate?
Also, I think that you may want to use the DATEADD() function because MS 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
October 4, 2007 at 7:01 am
SELECT TOP 1 *
FROM X
ORDER BY Something (ASC/DESC)
The ASC (ascending) will get you the first record, the DESC (descending) will get you the last record. Just remember that TOP processes...
"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 4, 2007 at 6:56 am
If you've got an existing system, monitor it to see what, if anything, is behaving badly. Start from there. Once you've identified the issues, you can start to make decisions...
"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 4, 2007 at 6:52 am
Viewing 15 posts - 21,721 through 21,735 (of 22,220 total)