New string function in SQL Server 2012 – FORMAT()

Formatting numbers in an SSRS report is a common task. For example, you may want to format a number as...

Silly issues with SSRS

Recently I was troubleshooting a report issue where in one of the column was empty in the report. I started...

Day 2: Log file grown high cannot shrink log file.(available size in – negative)

Description:-
Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user...

Execution plan warnings–The final chapter

In my previous posts (here and here), I showed examples of some of the execution plan warnings that have been...

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Error 823: IO error OS cannot read the data
Error: 823,...

CONCAT() – SQL Server 2012

With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of...

Promoted to Master Group By Thomas LaRock

SQLRockstar Thomas LaRock has updated his blogger rankings this month, and I was pleasantly surprised to see that he had...

SQL Server A to Z – Waits

In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running;...

DBA in Space Spoof Interview and Review

If you are a DBA in Space fan, and in case you missed them, there have been two items published...

Role-playing Dimensions

Dimensions are often recycled for multiple purposes within the same database.  For instance, a “Date” dimension can be used for...