Profile cover photo
Profile photo
Saurabh Gupta
66 followers
66 followers
About
Saurabh's posts

Post has attachment
How to find the fragmentation in indexes?
Below is the query to get the fragmentation of indexes in database. SELECT DB_NAME(database_id), OBJECT_NAME(p.object_id), s.name AS indexname, index_type_desc, avg_fragmentation_in_percent, page_count FROM sys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,N...

Post has attachment

Post has attachment
How to use Tablediff Utility?
SQL Server comes with many command line tools and one new tool that is available is the tablediff command. This tool help us to perform tasks: 1. Compare the two tables. 2. Tell us where any differences occur in the data between two tables. 3. Generate T-SQ...

Post has attachment

Post has attachment
How to add the computed column to a table based on the columns already exist in the table?
The application contains a table that has the following definition: CREATE TABLE Items (ItemID int identity(1,1) NOT NULL PRIMARY KEY, ItemsInStore int NOT NULL, ItemsInWarehouse int NOT NULL) You need to create a computed column that returns the sum total ...

Post has attachment

Post has attachment
Implementing Transparent Data Encryption (TDE)
Steps involved to implement TDE Step I - Create Mater
Key in Master Database USE master; GO CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'KeepSafeDB2014'; GO Step II - Create Certificate in Master
Database USE master; GO Create certificate TDECert with subjec...

Post has attachment

Post has attachment
Introduction to Transparent Data Encryption (TDE)
1. Introduced in SQL Server 2008 version. 2. It performs real-time I/O encryption and decryption of a SQL Server database's data and log files. 3. Use AES, 3DES encryption algorithm. 4. No application changes are required to take advantage of TDE. 5. Backup...

Post has attachment
How to identify and fix the Orphaned Users in SQL Server?
Wait while more posts are being loaded