Tags » T-SQL

Grouping the rolled up cube sets

Grouping is a fairly simple concept in SQL. You want that aggregated data? You better group it. But there’s so much more that can be done with a GROUP BY. 1,025 more words

Sql Server

SQL SERVER - Reverse String Word By Word - Part 3

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. 214 more words

SQL Authority

SQL SERVER - Proving that the Source of the Problems aren’t Tied to the Database

I have always wondered how Sherlock Holmes cracked the toughest of mysteries every single time. This fascination always lead me to learn new techniques every single time. 1,150 more words

SQL Authority

Does a clustered index sort the rows within a page

This is just something I was curious about. I ran my tests and got an answer and now I thought I would share.

Before I start I want to point out a few things about my tests. 1,290 more words

Microsoft SQL Server

SQL SERVER - Reverse String Word By Word - Part 2

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. 226 more words

SQL Authority

SQL SERVER - Can Database Primary File Have Any Other Extention Than MDF

Here is interesting question I received yesterday. I personally think it is one of the most interesting questions I have received this month.

“Can Database Primary File Have Any Other Extention Than MDF?”

141 more words
SQL Authority

SQL SERVER - Download RML Utilities for SQL Server

Microsoft RML Utilites are very helpful when analysing performance. It helps answering questions like

  • Do you know which databases are using the most resources on your server?
  • 82 more words
SQL Authority