This is very interesting error as I could not found any documentation on-line. It took me nearly 1 hour to figure out what was creating error.
SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files
Many times I have been asked how to change the result window from Text to Grid and vice versa. There are three different ways to do it. Method 1 : Key-Board Short Cut Results to Text – CTRL + T Results to Grid – CTRL + D Results to File…
Read MoreSQL SERVER – SPACE Function Example
A month ago, I wrote about SQL SERVER – TRIM() Function – UDF TRIM() . I was asked in comment if SQL Server has space function? Yes. SELECT SPACE(100) will generate 100 space characters. The use of SPACE() function is demonstrated in BOL very fine. Example from BOL: USE AdventureWorks;…
Read MoreSQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup
The questions I received in last two weeks: “I do not have backup, is it possible to restore database to previous state?” “How can restore the database without using backup file?” “I accidentally deleted tables in my database, how can I revert back?” “How to revert the changes, I have…
Read MoreSQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable
This article is as per request from Application Development Team Leader of my company. His team encountered code where application was preparing string for ORDER BY clause of SELECT statement. Application was passing this string as variable to Stored Procedure (SP) and SP was using EXEC to execute the SQL…
Read MoreSQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability
Microsoft TechNet frequently releases White Papers on SQL Server Technology. I have read the following two white papers recently. The summary of its content is here. Analysis Services Query Performance Top 10 Best Practices Optimize cube and measure group design Define effective aggregations Use partitions Write efficient MDX Use the…
Read MoreSQL SERVER – SQL Joke, SQL Humor, SQL Laugh – 15 Signs to Identify Bad DBA
15 Signs to Identify Bad DBA They think it is bug in SQL Server when two NULL values compared with each other but SQL Server does not say they equal to each other. They do not rename the trigger name thinking it will not work after it is rename. They…
Read More