Welcome to SqlAdvice Sign in | Join | Help

February 2008 - Posts

Wednesday, February 13, 2008 8:43 AM

Determine SQL Server Version

If you need to know the version you are currently running of SQL Server you can easily get it by running the following query. SELECT ' SQL Server ' + CONVERT ( varchar ( 100 ),SERVERPROPERTY( ' productversion ' )) + ' - ' + CONVERT ( varchar ( 100 ),SERVERPROPERTY(
Posted by gstark | 2 Comments
Tuesday, February 12, 2008 4:34 PM

Arithabort Option Affects Stored Procedure Performance

I have noticed that at times I will have a stored procedure start to take an unusual amount of time to complete. In trying to debug this I grab the SQL that is being called from the application and paste it into SQL Server Management Studio only to have
Posted by gstark | 19 Comments