Since someone else may have the same problem and find this thread, can you post your solution?

Thanks Roy.

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...

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,...

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...

Oh, I made the mistake of following up on his thread... encouraging bad behavior. "Bad, Grant, Bad! Down! Stay!"

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...

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...

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.

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?...

john.arnott (7/28/2009)

Just be careful of starting an internecine battle. There are more of we developers...

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...

Luke L (7/28/2009)

And of course a ppt preso won't quite cut it. Perhaps use Grant...

Yep. Once a month. We'd love...

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].