Below is the script to find the fragmentation of the indexes created on a database.
SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,
avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count
FROM sys.dm_db_index_physical_stats (DB_ID( N'Database name')...
2015-01-07 (first published: 2015-01-04)
7,209 reads
Below is the query to find out all the Queries and their details like SSID etc. running on the SQL...
2015-01-04
1,560 reads
Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view,...
2015-01-03
999 reads
Technical Round Database Interview Questions
1) What are the different types of Trace flags which we used for detecting the Deadlock?
2)...
2014-11-03
1,355 reads
Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation.
7 Bad Management...
2014-10-19
575 reads
Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the...
2014-10-12
1,457 reads
SQLTea - Our new SQL Tutorial App on Google Play StoreWe are happy to announce our new SQL tutorial app SQLTea...
2014-08-18
1,366 reads
In this article, I am going to explain the process of Database restoration using the SQL Server Management Studio. In...
2014-08-17
977 reads
This article explain the simple way to take up the backup of a database which can be easily understandable by...
2014-08-17
888 reads
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command....
2014-08-17
935 reads
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Comments posted to this topic are about the item Step by step guide to...
Comments posted to this topic are about the item Backing up the Database Encryption...
Comments posted to this topic are about the item Technology Fears
In my SQL Server 2022 database, I run this:
USE Sales; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE MyServerCert; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers