Hi, Often when you try to restore a database there will be connections to the DB, which will stop the restore from succeeding. What I […]
SQL Server SHRINKFILE not working
As microsoft put in in SQL Server Books online, “A shrink operation is most effective after an operation that creates lots of unused space, such […]
SSIS Date conversion error going from Oracle to SQL Server
Hi, The other day I had the task to move a large amount of data from Oracle to SQL Server. I had chosen to import […]
SQL Server Excel and Soft Returns
Many moons before reporting services existed, I was involved in writing a report architecture which was based upon SQL server and MS Excel. In short […]
SQL Server 2008 R2 Nov CTP – Uninstall issues
I was attempting to uninstall the SQL Server 2008 R2 Nov CTP and I found the SQL server 2008 R2 (x64 in my case) uninstaller […]
SQL Server 2008 Uninstall – Restart Computer Failure
Sometimes when attempting to uninstall SQL Server, “Setup Support Rules” performs a check and fails on “Restart Computer” with the following error; “A computer restart […]
SQL Server Date Format – Convert to varchar
Below is a nice little script to output the various formats displayed by sql server when using convert(varchar, getdate(), n). It just outputs the current […]
SQL Server Reporting Services (SSRS) – IIF statement divide by zero error
If you use the IIF statement to solve your divide by zero errors, you will most likely find that you still get divide by zero […]
SQL Server Reporting Services – Access textbox value in expression
If you need to progamatically access a control on your report then use the following expression
SQL Server Print Logging in TSQL / Stored Procedures
In tsql when running stored procedures you may wish to output debug statements. The problem is that in a long running tsql the “Print” statements […]