et's take following sample table and data to know about RANK, RANK_DENSE, NTILE and ROW_NUMBER with examples. Create table ExamResult(name varchar(50),Subject varchar(20),Marks int) insert into ExamResult values('Adam','Maths',70) insert into ExamResult...
Following are the different types of isolations available in SQL Server. READ COMMITTED READ UNCOMMITTED REPEATABLE READ SERIALIZABLE SNAPSHOT Let us discuss about each isolation level in details.Before this, execute following script to create table...
SQL Server Index Fragmentation In-depth There is no way to avoid index fragmentation in any SQL Server environment. It does not depend on your SQL Server version or I/O subsystem you have, or your hardware. In this article, we will drill down into SQL...
How to restore database using Litespeed backup file and TSQL command Below is TSQL script to restore database in MSSQL using Litespeed backup file. exec master.dbo.xp_restore_database @database = N'databasename' , @filename = N'Full path of the backup...
DIFFERENCES BETWEEN 2005 AND 2008 AND 2008 R2 AND 2012. DIFFERENCES BETWEEN 2005 AND 2008 AND 2008 R2 AND 2012. SQL Server 2005 to 2008 • Transparent Data Encryption. The ability to encrypt an entire database. • Backup compression is available (only in...
w Features in SQL Server 2012:- AlwaysOn Availability Groups – AlwaysON Availability Groups is a revolutionary feature which replaces many other features such Database Mirroring, Logshipping and up to an extent Replication. AlwaysON also known as HADRON,...
Ticketing tool improves communications tracking whatever is happening in the environment, reporting that what has happened within the specific duration. A Ticket is an element contained within an issue tracking system which contains information about...
What is Fragmentation? How to detect fragmentation and how to eliminate it? Storing data non-contiguously on disk is known as fragmentation. We can classify fragmentation into two types: Internal Fragmentation: When records are stored non-contiguously...
Working on Disk space issue... 1. login into the server. verify below options.. Disk space issue ============== 1. old installation files and service pack files 2. data and log files has to be verify. 3. backup files. 4. error log size 5. sqlagent.out...
