SQL Server Articles

Most Recent Articles

• • 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: 0  -  Views: 554
• • 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: 0  -  Views: 769
• • 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: 3389
• • 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: 10580
• • 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: 3206
• • 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: 21051
• • 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: 41936
• • 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: 3409
• • 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: 7979
• • Email
  SQL Server: x
  x
  Sarabpreet Anand   -  3/1/2012 7:53:51 AM   -  Comments: 0  -  Views: 207
• • 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: 1938
• • 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: 896
• • 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: 1  -  Views: 49339
• • 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: 5804
• • 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: 287
• • Email
  SQL Server: How to find column related detailed info for any table?
  If i ask you to get me a list of all the columns in 25 tables those are being replicated or being used by certain application module, how will you get this info? I know most of you will opt for getting the info manually, but if this becomes a routine acti...
  tags : all column names, catalog view, Column info, Schema of table, sys.columns
  Sarabpreet Anand   -  3/1/2012 7:36:17 AM   -  Comments: 2  -  Views: 27575
• • Email
  SQL Server: Enable Powershell Feature in Windows Server 2008 R2
  In this article i'll show you the steps to Enable PS in Windows Server 2008 R2. Windows Server 2008 gets shipped with Powershell v1.0. But it is disabled by default to reduce the Surface Area of Windows. If you want to use powershell, you can easily Enabl...
  tags : Enable Powershell Feature, Powershell, PS, Windows Server 2008 R2
  Sarabpreet Anand   -  3/1/2012 7:35:33 AM   -  Comments: 0  -  Views: 3697
• • Email
  
  SQL Server: DB Mail Account Creation Failed - A Bug
  One fine day i was configuring DB Mail on one of my server and while configuring Mail Account i encountered the following error. Error Unable to create new account SQLServerGeeks for SMTP server Microsoft.SqlServer.Management. SqlManagerUI. SQLiMailServer...
  tags : SQL Server 2008, Account, Bug, Database Mail, DB Mail, Profile, applicable to SQLServer 2008 SP1 Standard Edition 64-bit
  Sarabpreet Anand   -  3/1/2012 7:32:33 AM   -  Comments: 3  -  Views: 14665
• • Email
  
  SQL Server: Slowly Changing Dimension Part 2
  This is a follow up article for Slowly changing dimensions. This article aims to provide insights for Type 4, Type 6 and lastly the 'Combining Type'.
  tags : Data warehouse, SCD
  Raunak Jhawar   -  3/1/2012 7:31:13 AM   -  Comments: 0  -  Views: 26376
• • Email
  
  SQL Server: SSAS Perspective
  A perspective is a subset of a cube created for a particular application or group of users. The cube itself is the default perspective. A perspective is exposed to a client as a cube. When a user views a perspective, it appears like another cube.
  tags : Data warehouse, Analysis Services, Perspective, SSAS
  Raunak Jhawar   -  3/1/2012 7:28:28 AM   -  Comments: 1  -  Views: 16302
• • Email
  
  SQL Server: Compare the Data in Two Tables without Any 3rd-Party Tool
  For comparing data in tables you don't need any 3rd party tool, SQL Server ships with the tablediff utility which can be used to compare the data in two tables. You can use it for troubleshooting replication. This utility can be used from the command prom...
  tags : compare, data comparison, replication, table, tablediff, values
  Sarabpreet Anand   -  3/1/2012 7:27:52 AM   -  Comments: 0  -  Views: 157883
• • Email
  
  SQL Server: Role Playing Dimension
  In plain terms, a role playing dimension would mean a “morphed actor”. The actor remains the same, but is made available to the requirement in different forms or even in multiple forms. This is precisely what can be called as polymorphism that we understa...
  tags : Data warehouse, Role Playing Dimension
  Raunak Jhawar   -  3/1/2012 7:27:20 AM   -  Comments: 0  -  Views: 5168
• • Email
  SQL Server: Restoring a Database – One Such Approach in an Emergency
  Performing a Database Restore is a part of a DBA’s daily life. He might need to perform a Restore due to various reasons such as Recovery, Refreshing a database for testing purpose and so on. However many times it becomes too difficult to perform a Restor...
  Satnam Singh   -  3/1/2012 7:26:47 AM   -  Comments: 2  -  Views: 24284
• • Email
  SQL Server: Controlling Growth of a msdb Database
  I recently encountered a situation where the drive hosting Sharepoint Databases in a Staging environment ran out of space. I logged onto the server and found that the msdb database has itself occupied 38 GB of the total disk space. Msdb database generally...
  tags : controlling growth, msdb database
  Satnam Singh   -  3/1/2012 7:25:31 AM   -  Comments: 1  -  Views: 16151
• • Email
  SQLServer:Transactional Replication-A Much Better Approach For Creating User Friendly Alert Messages
  As DBAs, we are often required to set up alert notification emails for various tasks. For example, there might be a requirement to set up notification alerts if a particular backup job fails. A while back, I came across the situation where I was asked to ...
  Satnam Singh   -  3/1/2012 7:25:08 AM   -  Comments: 0  -  Views: 18699