I just stumbled across a weird misconception that I'd like to help you to avoid: If you consume the results of a (non-inline) table valued function, the results are not in the same order as if you take the content óf the TVF in your query. So, if you h...

I just stumbled across a weird misconception that I'd like to help you to avoid: If you consume the results of a (non-inline) table valued function, the results are not in the same order as if you take the content óf the TVF in your query. So, if you h...

The execution plan looks fine so far. I'm sure you could do better, but I couldn't find anything below 4 scans. Maybe I should look into the SQL2012 instruction set ...

Suppose we have a table whose structure is given below Create table addcounter( counterid int identity(1,1) ) Now how can we insert values in the table?...

Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....

I wanted to have a simple select, no recursion, no CTE. I think it's still readable and hope it can compete with regard to time and space.

I wanted to have a simple select, no recursion, no CTE. I think it's still readable and hope it can compete with regard to time and space.

These properties are useful when you export reports to Excel workbooks. Use the **InitialPage** property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the **PageName** property to provide dif...

These properties are useful when you export reports to Excel workbooks. Use the **InitialPage** property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the **PageName** property to provide dif...

These properties are useful when you export reports to Excel workbooks. Use the **InitialPage** property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the **PageName** property to provide dif...