Welcome
SQLAdvice.com is an online community for SQL Experts, Users, and anyone interested in learning more about SQL and databases. In addition to our Forums and Blogs, be sure to check out the mailing lists, which presently require a separate login.
-
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(...
-
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...
-
This has to go down as one of the strangest requirements for a contest ever. Check out the official rules for VMWare's contest to win an iPhone. In section 4 "Selection of Winner" it states "Canadian residents, if selected as a winner, must correctly...
-
Microsoft has released the latest SQL Server 2008 CTP. This release has tons of new features including Intellisense for SSMS. This one also includes the spatial datatypes which I know a lot of people have been waiting for. You can go get the newest CTP...
-
I set all my tool bars to be fly outs and it is fairly annoying how slow the animation is. I found this link and decided to try it out and it works great! http://blogs.msdn.com/euanga/archive/2007/10/01/ssms-window-animation-speed.aspx I would be interested...