SQL Server Articles

Most Recent Articles

• • Email
  
  SQL Server - What Is A Cursor?
  Cursors are database objects used to manipulate data in a set on a row-by-row basis; it acts just like a recordset in ASP and Visual Basic. We can also fetch cursor rows and perform operations on them in a loop just like using any looping mechanism found ...
  tags : SQL Server, Cursor, ISO Syntax, Transact-SQL Syntax
  Piyush Bajaj   -  10/6/2012 1:25:30 PM   -  Comments: 3  -  Views: 27055
• • Email
  
  SQL Server – What is Common Table Expression (CTE)?
  The Common Table Expression (CTE) was introduced earlier in the SQL Server 2005. The CTE defines about a temporary view, which can be referenced just like a view in the same query. The CTE’s can be used in the same ways that simple Subqueries are used and...
  tags : Common Table Expression (CTE) in SQL Server, CTE, How to create CTE in SQL Server, How to use CTE in SQL Server
  Piyush Bajaj   -  10/3/2012 6:36:46 AM   -  Comments: 7  -  Views: 64866
• • Email
  
  SQL Server - How to Generate XML Output Using FOR XML? – PART 1
  While passing the parameter on it; SELECT E_Id, E_Name FROM Emp FOR XML AUTO, ROOT('TCS') The result can be seen as:
  tags : SQL Server, FOR XML, FOR XML AUTO, What is FOR XML?
  Piyush Bajaj   -  9/19/2012 9:21:39 PM   -  Comments: 0  -  Views: 2535
• • Email
  A DBA's Approach To Setup Transactional Replication - 4 NonStop Days At Office
  Replication without a Snapshot.
  tags : Replication without a Snapshot, Setting up Transactional Replication in SQL Server 2005
  Satnam Singh   -  8/27/2012 2:54:49 AM   -  Comments: 1  -  Views: 2021
• • Email
  Understanding SQL Server Performance Tuning - Why DateAdd is performing too slow.
  Dateadd performing too slow,proper tuning of the SQL Statements in the dateadd condition.
  Satnam Singh   -  7/22/2012 5:54:58 AM   -  Comments: 8  -  Views: 3139
• • Email
  Somebody Has Manually Performed a DML Operation on the Subscriber - What to do next.
  Somebody Has Manually Performed a DML Operation on the Subscriber - What to do next.
  tags : Error No 20598 in Transactional Replication, Somebody Has Manually Performed a DML Operation on the Subscriber - What to do next.
  Satnam Singh   -  7/17/2012 6:14:08 AM   -  Comments: 1  -  Views: 2778
• • Email
  A Deep Dive into Transactional Replication
  A Deep Dive into Transactional Replication;Replication without a Snapshot;Proper Backups of Indexes and Statistics for Optimal Performance of the Reporting SQL Server.
  Satnam Singh   -  7/5/2012 5:15:21 PM   -  Comments: 3  -  Views: 2480
• • Email
  Why is NTEXT so bad to give a PAIN.
  Why is NTEXT so bad to give a pain to a DBA
  Satnam Singh   -  7/2/2012 7:16:11 PM   -  Comments: 5  -  Views: 2825
• • Email
  Designing a Proper Backup Plan.
  Designing a Proper Backup Plan.
  Satnam Singh   -  6/21/2012 11:45:59 AM   -  Comments: 3  -  Views: 4006
• • Email
  An example of Real Point In Time Recovery
  An example of Real Point In Time Recovery
  tags : Accidentally deleted the records, Point in Time Recovery
  Satnam Singh   -  6/14/2012 7:02:23 PM   -  Comments: 4  -  Views: 3442
• • Email
  Setting up Transactional Replication for Huge Databases - A Real World Scenario.
  Setting up Transactional Replication for Huge Databases without Creating a Snapshot.
  tags : Replication without a Snapshot, Setting up Transactional Replication, SQL Server Replication
  Satnam Singh   -  5/2/2012 4:31:19 AM   -  Comments: 5  -  Views: 4189
• • Email
  
  Multiple NULL values in UNIQUE constraint
  A unique index guarantees that the index key contains no duplicate values and therefore every row in the table is in some way unique. Specifying a unique index makes sense only when uniqueness is a characteristic of the data itself. With multicolumn uniqu...
  tags : SQL Server, multiple null values, unique constraint, unique index
  Ravi Kumar   -  4/24/2012 7:24:23 AM   -  Comments: 2  -  Views: 6208
• • Email
  
  SQL Server: Index Fill Factor
  FILLFACTOR, The FILLFACTOR option allows you to allocate a percentage (0 to 100) of free space on the leaf-level index pages to reduce page splitting. This option is many-a-times overlooked and just left set to the default engine setting without knowing t...
  tags : Fill Factor, Index, SQL Server, Clustered Index, DBCC ShowContig, Fragmentation
  Sarabpreet Anand   -  3/1/2012 8:19:59 AM   -  Comments: 4  -  Views: 6829
• • Email
  SQL Server: The hidden power of Surface Area Configuration Tool
  SQL Server 2005 comes with a Surface Area Configuration tool. But the Problem is...... This tool works perfectly fine if you want to manage an instance and want to reduce the surface area. But if you are in an environment where you need to manage many SQL...
  tags : SAC, SQL Server 2005, Surface Area Configuration Tool
  Sarabpreet Anand   -  3/1/2012 8:17:59 AM   -  Comments: 5  -  Views: 12871
• • Email
  
  SQL Server: Resource Database
  Resource database is a read-only and hidden database. Resource DB physically contains all the system objects that accompanies with SQL Server.
  tags : Resource Database, SQL Server System Database
  Sarabpreet Anand   -  3/1/2012 8:16:15 AM   -  Comments: 5  -  Views: 6570
• • Email
  
  SQL Server: Auto-Truncate Log in Full Recovery Model
  Your database can be in Auto-Truncate Mode while the recovery model is set to FULL. In this article i will explain you the different conditions which changes this behaviour & let you know how to avoid such pitfalls and make your database fully recoverable...
  tags : log sequence number, LSN, Recovery model, sys.database_recovery_status
  Sarabpreet Anand   -  3/1/2012 8:15:10 AM   -  Comments: 6  -  Views: 33798
• • Email
  SQL Server: Restrict the use of NO_LOG and Truncate_Only
  The real point of FULL or BULK_LOGGED recovery model is to keep the transaction log so that the database can be recovered right up to the point of a failure, or to do point-in-time recovery. Using BACKUP LOG WITH NO_LOG negates all of that by breaking the...
  tags : No_Log, Transaction Log Truncation, Truncate_Only
  Sarabpreet Anand   -  3/1/2012 8:14:12 AM   -  Comments: 2  -  Views: 43721
• • Email
  
  SQL Server: Sum of values for Time Slots
  Find sum of values for a fixed time slot
  Sachin Nandanwar   -  3/1/2012 7:55:42 AM   -  Comments: 1  -  Views: 5460
• • Email
  SQL Server: Controlling the growth of msdb database caused by Database Mail
  Database Mail can be one of the causes to increase the size of the msdb database. Other causes are Agent job history, maintenance plan history, and backup and restore history etc. Hence it is important to have some data retention policy in place and accor...
  tags : SQL Server System Database
  Amit Karkhanis   -  3/1/2012 7:54:45 AM   -  Comments: 11  -  Views: 12572
• • Email
  SQL Server: x
  x
  Sarabpreet Anand   -  3/1/2012 7:53:51 AM   -  Comments: 0  -  Views: 639
• • Email
  
  SQL Server: Range query Indexes
  Indexes to be used with range queries
  Sachin Nandanwar   -  3/1/2012 7:52:46 AM   -  Comments: 0  -  Views: 3664
• • Email
  SQL Server: finding the month in which sales crossed a certain figure
  Members are requested not to post Questions as an Article. This Question(Article) reposted in Forum Section: Here Admin
  ravinder ravinder   -  3/1/2012 7:51:50 AM   -  Comments: 0  -  Views: 1617
• • Email
  
  SQL Server: Backing up an Analysis Services Database automatically – Part 1
  This article shows you a few ways to backup your Analysis Services database automatically. This is part 1 in the 2 part series.
  tags : Analysis Services database backup automatically, OLAP db backup automatic, SSAS backup
  Amit Bansal   -  3/1/2012 7:50:46 AM   -  Comments: 4  -  Views: 56361
• • Email
  SQL Server: FileGroups?
  SQL Server maps a database over a set of operating-system files. Data and log information are never mixed in the same file, and individual files are used only by one database. The use of Filegroup is limited to Data Files only. Database objects and files ...
  tags : create object in another filegroup, data placement control, datafile, Filegroups, secondary filegroup
  Sarabpreet Anand   -  3/1/2012 7:48:25 AM   -  Comments: 0  -  Views: 10585
• • Email
  SQL Server: Anonymous Access for SSRS 2008/R2
  Anonymous Access for SSRS 2008/R2
  Raksh Mishra   -  3/1/2012 7:37:29 AM   -  Comments: 0  -  Views: 1212