Viewing 15 posts - 16,861 through 16,875 (of 22,226 total)
You can't refer to an alias as a column. Instead of this:
AND CONVERT (INT ,[True Arrears Balance]) > 0
You would need to do this:
AND ((CAST(TEN.[curr-balance] AS INT) + CAST(TEN.[hb-arrears] AS...
"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
July 29, 2009 at 8:32 am
You're trying to add a string to an INT field in the first query, which isn't possible. Your attempted fix is trying to convert the string to a number, again,...
"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
July 29, 2009 at 8:14 am
Except of course for the hard way, create a new table with the new structure, drop all the constraints on the old table, copy the data over, put the constraints...
"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
July 29, 2009 at 7:34 am
Oh, I made the mistake of following up on his thread... encouraging bad behavior. "Bad, Grant, Bad! Down! Stay!"
"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
July 29, 2009 at 7:07 am
It sounds like it was building out execution plans for all the recursions (guess). Instead of trying to get the execution plan by running the query in SSMS, try querying...
"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
July 29, 2009 at 6:54 am
As long as you don't use the INIT clause, you can simply add differentials to the same backup file. That's not how I prefer to do it. I like 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
July 29, 2009 at 6:40 am
And fill factor is applicable when creating or rebuilding an index. Once an index is operation or it gets reorganized, fill factor is no longer taken into account.
"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
July 29, 2009 at 6:39 am
Two instances on a machine do have two different ports. They can be dynamically assigned. You say you have TCPIP enabled. Do you have the SQL Server Browser service running?...
"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
July 29, 2009 at 6:28 am
john.arnott (7/28/2009)
Steve Jones - Editor (7/28/2009)
How about advanced pork chop aiming strategies for maximum developer damage?
Just be careful of starting an internecine battle. There are more of we developers...
"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
July 28, 2009 at 12:46 pm
NULL values are not your friend when it comes to indexes. You will get a scan. Even forcing the use of the index through the hint will result in a...
"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
July 28, 2009 at 10:21 am
Luke L (7/28/2009)
Steve Jones - Editor (7/28/2009)
How about advanced pork chop aiming strategies for maximum developer damage?
And of course a ppt preso won't quite cut it. Perhaps use Grant...
"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
July 28, 2009 at 10:16 am
Jack Corbett (7/28/2009)
Do you guys meet monthly?The next time I'm in New England maybe I can schedule to be your area around a meeting time.
Yep. Once a month. We'd love...
"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
July 28, 2009 at 10:15 am
I just validated it, you can get the start time for a statement within a batch by querying sys.dm_exec_sessions. I posted a blog entry on it here[/url].
"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
July 28, 2009 at 9:27 am
Jeff Moden (7/28/2009)
Grant Fritchey (7/28/2009)
Jeff Moden (7/27/2009)
Grant Fritchey (7/27/2009)
"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
July 28, 2009 at 9:24 am
There is no process for creating system catalog views. They are part of the normal running of the system and will be there after a successful install.
Are you sure...
"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
July 28, 2009 at 5:45 am
Viewing 15 posts - 16,861 through 16,875 (of 22,226 total)