SQL Server Query Store (SQL SERVER 2016)
Among that all the features of SQL server below i will discuss only Query Store in SQL SERVER 2016:- Query Store is a new SQL Server...
Update Second Row if two rows has same values
Here i want to Update the Second repeated digit Like (3 as 6) without any Unique column. As per above given attach. Query : create table...
Strign repeated in a row
/*How to count a string that number of times has repeated in a table rows. Here i just passes the values by dynamically. please lets have...
Select all columns but Group by only some selective column :-
Some times we want to count duplicates over multiples column but output should return all the column from the table. In this case we can...
create .mdf .ldf and .ndf into different location
CREATE DATABASE TestON PRIMARY(NAME = Test_Data, FILENAME = 'C:\SQL\Test_Data1.mdf'),FILEGROUP [OrderHist] (NAME = Test_Hist1, FILENAME =...
Check current executing Query over the server :-
Some times we are inserting bulk data into the production but we are not able to insert. The reason behind it it may be an another user...
The Role of MDF and LDF in SQL SERVER
Now a day all the companies need a system to store data and again they can retrieve it for their own purpose. The Information can be...
SQL Server top 50 interview Question for DBA
Top 50 SQL interview question: Ques.1. What is database testing? Ans. Database testing is checking the integrity of actual data in the...
Create an user define file group and take backup for it :
There are two types of SQL Server filegroups: primary and user-defined. Primary filegroup includes all pages for system tables, primary...
Total execution time for an SP
/*Keep a record to take the total execution time for SP*/ I am dynamically passing the values like SP name and parameter are using for...
