SQL Script to find the missing indexes
Performance tuning in SQL is important exercise and index creation is an important part of it. Below script will help in finding the...
2015-01-25
16,219 reads
Performance tuning in SQL is important exercise and index creation is an important part of it. Below script will help in finding the...
2015-01-25
16,219 reads
In relational database, we store data in tabular form where data is divided into columns. Each column has a name...
2015-01-25
834 reads
Convert () function in SQL Server to convert an expression from one data type to another data type
Syntax for CONVERT function
CONVERT ( data_type [ ( length ) ] , expression...
2015-01-24
1,850 reads
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below...
2015-01-20
2,440 reads
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used...
2015-01-20
631 reads
Below is the SQL query which can be used to find out the tables which are created or modified on...
2015-01-20
632 reads
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used...
2015-01-20
583 reads
Below query can be used to see the growth size of database files.
DECLARE @filename NVARCHAR(1000);
DECLARE @bc INT;
DECLARE @ec INT;
DECLARE @bfn...
2015-01-09
1,517 reads
Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we...
2015-01-09
1,365 reads
Sometimes we needs to find out the last executed commands on the database server.
Below is the SQL script share by...
2015-01-08
1,901 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers