Tags » T-SQL

Compressing Open Row Groups

If you’re using, or at least read up on Clustered Columnstore Indexes then you’ll know that the data is stored in segments. You’ll also know that there are 4 states the segments can be in at any one time: 2,439 more words


SQL SERVER - SSMS: Performance Dashboard Reports - Home Page details

Earlier we discussed in detail what the SSMS: Server Dashboard Report looks like when working with SQL Server Management Studio standard reports. These dashboard reports are an arsenal of amazing wealth of information packed in one single view. 848 more words

SQL Authority

Finding out most recent queries run on a specific database

I found this useful script online to find out the queries run on a specific database.  This script is useful when you are trying to go back and find out what was ran on the database. 54 more words


Changing configuration settings with sp_configure

I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that I realized that the existence of sp_configure is probably not universal knowledge. 366 more words

Microsoft SQL Server

SQL SERVER - SSMS: Performance Dashboard Installation and Configuration

If the standard set of reports were not enough, in this blog, let me introduce an interesting addition to the reports. This is called as Performance Dashboard reports. 571 more words

SQL Authority

Identifiers in T-SQL

From time to time, you’re going to be confronted with a SQL Server solution where you need manage column or table names that contain non-alphanumeric characters, like for instance space or percent, or even reserved keywords like “table” or “select”. 633 more words