Do you find yourself in the situation where you want to audit or check what is happening with your server in terms of queries? Or maybe you are in a more unpleasant situation and you need to recover a query after a SQL Server crash or a server crash. Either way, the following script will Read More
Grouping sets in SQL Server always comes into handy when you find yourself in the need to perform data aggregation based on groups. The groups are made by defining a set of attributes that the engine will use to split the data.
The following script will help you to get all the columns with different collation than the one specified as default for a database.
One thing I believe it’s important for everyone who is interested in the database business is the way logical query processing works. And it’s interesting to observe that even some experienced developers have problems interpreting how a query gets processed by SQL Server. In this article, I intend to explain the best I can how Read More
You can easily find yourself in the need to know the tables with no existing rows from a database, especially in data warehousing scenarios.