Database Optimization: Indexes
I noticed that very few people understand how indexes work in SQL Server, especially Included...
Methods to Rank Rows in SQL Server: ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE()
SQL Server provides us with a number of window functions that help us to perform calculations across a set of rows, without the need to...
Setting Database Access Permissions
Server security mainly depends on how correctly you can configure access permissions on objects. Providing a user with excessive...
Performance of Table Variables in SQL Server
In this article, we are going to touch upon the topic of performance of table variables. In SQL...
Understanding Pivot Operator in SQL
The pivot operator in SQL Server converts each row in the aggregated result set into corresponding columns in the output set. The pivot...
Sending a Query to All Databases of All Specified Servers in MS SQL Server and C#.NET
Often, it is necessary to send a query to all databases of all specified servers. Many DML-queries can be created with built-in tools....
How to Analyze Activity of One Database in SQL Server
Using one SQL Server instance for many projects is not unusual. However, defining the most active...
How Simple Is It to Move Data from Excel to SQL Server?
What could be simpler than to get data from an Excel table in SQL Server? There are many ways to accomplish this task. You can utilize...
Common Mistakes of DBA in MS SQL Server
In this article, we are going to review DBAs mistakes, the consequences of which were quite perceptible and which I had to deal with. The...
How to Automate Data Collection on the SQL Server Database Growth
Introduction Often, there is a need to control the growth of all tables and files of all databases....
