I have a view that has 2 columns. The first column is associated with a function for the Units. The second column calculates the Market Value: View...
No tempdb and no schema change. But the stored procedures involve heavy calculations and insert/update. Don't know if Lock:timeout events are costed...
I see Lock Timeout events in Profiler but none of the stored procedures running set the @@lock_timeout variable. Select @@lock_timeout returns -1...
I have a system that performs a lot of heavy background calculations and as the same time sevring web users. How do I increase performance and reduce...
How much performance trade off should I expect to use FOR XML to generate XML string directly from SQL Server? I like this approach because it is...
Separate names with a comma.
