Mar 25, 2009
# 3,220
Recently I had troubles restoring a database in my SQL Server 2005 instance (SP3). I used the ‘wizard’ in the SQL Server Enterprise manager but after I got the message ‘restore completed successfully’ the database hung in ‘Restoring’ state, blocking connections. read more →
Nov 15, 2006
# 364
Control structures syntax; IF THEN ELSE, CASE, WHILE . read more →
Nov 3, 2006
# 2,206
Cursors in tsql, it can be done … read more →
Nov 1, 2006
# 655
Returing values into tsql variables from a dynamic sql statement using sp_executesql stored procedure. read more →
Sep 18, 2006
# 275
Getting around in the mssql environment read more →
Sep 17, 2006
# 651
Date time functions (frustrations) in T-SQL. read more →