Here we will discuss on Waits in the context of SQL Server: Highlights of this video blog :- 1. What is wait and why we need to focus on wait? 2. Lifecycle of a session 3. Analogy to explain waits 4. Types of Waits. 5. Where to see waits...

While installing sql server 2008 setup we might face following warning in the installation window Receive a warning about the network binding order on the Setup Support Rules page when install SQL Server 2008 in a failover cluster The domain network...

SQL Server Performance Dashboard Reports in SSMS – Introduction, Install, DateDiff error & Modified for SQL 2008 Many of you seasoned DBA’s out there would have heard about the SQL Server 2005 Performance Dashboard Reports and used...

SQL Server 2008 setup may fail with the following error even though you are running the setup as administrator. You might get these kind of errors in Detail.txt after you cleaned up an failed setup (from Add/Remove Programs) and try to run the setup again...

/*** Note: Kindly follow the Instruction in each step ***/ /*** If you are using SQL Server 2008 Management Studio, Ctrl-Shift-M might not work. In that case go to “Query” menu and click on “Specify Values for Template Parameters” ***/ 1) Logon...

Right, ever heard or wondered about snapshot backups in SQL Server? You might have come across the Volume Shadow Service (VSS) backup option in SQL Server. In this post, I will try to explain what they are, how they work and what to check for when you...

What will happen if the indispensible SSMS crashes or worse just hangs? A lot of fretting!! (For the not-so SQLCMD savvy)....!! I have enclosed here two scenarios and their corresponding resolutions PROBLEM 1 When we start up SQL Server Management...

Network Binding Order Rule Warning in SQL Server 2008 Cluster Setup Explained This blog present some more information about the “network binding order” setup rule that is present in SQL Server 2008. We have another blog that talks about the issues...

There can be many reasons for the size of Transaction Log growing large for a sql server database such as waiting on checkpoint, backups in Full recovery model, active long running transaction. The simplest and the smartest way to determine the...

Recently we encountered an issue while installation of client tools in sql 2005, so I would like to share the same in the following blog Problem Description The installation of the Client tools in SQL Server 2005 fails with the following error...

One of the Best practice for database mirroring(DBM) is to setup DBM on dedicated NIC card\Network adapter, as mentioned in http://msdn.microsoft.com/en-us/library/cc917681.aspx The idea is to transport the mirroring traffic via a dedicated network...

Some of you may experience problems while using Database Mail on SQL Server 2005 or SQL Server 2008 which will not be able to send emails to the database users. The SQL Server error logs will log following errors: The activated proc [dbo].[sp_sysmail_activate...

We at SQL Server support team, continue to invest our time in writing tools and utilities which can aid you in troubleshooting SQL Server issues. SQL Server Backup Simulator is one such tool which will help you while troubleshooting issues in taking backup...

Recently we faced an issue where in clustered instance of sql server 2005 was taking long time to come online on a windows 2008 cluster. We checked the Error log and found the following 2009-10-05 10:58:27.41 Server Attempting to initialize...

We have seen a couple of cases, wherein we are unable to create maintenance plan or DBMail Fails after applying SP on SQL Server 2005 failover cluster instance running on Windows 2008 Cluster . Resource Database and other system databases may not be...

Let’s start with a little background on how SQL Server logins and Database users actually work. A login (Windows/SQL authenticated) gives you the permissions to log onto a SQL Server instance. With the help of the login, an individual can access the databases...

Consider a scenario where you are doing a new install ation of SQL Server 2000 MSDE on a computer and you get messages like: Setup failed to configure the server. Refer to the server error logs and setup error logs for more information Normally...

(How to uninstall SQL Server 2005 Cluster / How to break SQL Server 2005 Cluster ) There will be situations where you want to perform any of below task: 1.        Convert two node SQL cluster to standalone instance of SQL...

Many times we need to reinstall a sql server instance due to number of reason. Whenever you reinstall the sql server instance the success of the installation of the new sql server instance primarily depends on the whether the previous uninstall of...

Maintenance Plans with “Backup Database Task” fails when the “Create a sub-directory for each database” option is checked, with error similar to the below, “Cannot open backup device 'D... The package execution fa... The step failed.,00:00:01,0,0,...

Q: What is Preallocate Setting? Answers: Preaallocate Setting specifies a certain percentage of memory be allocated to Analysis Services when the service starts (memory preallocation). This configuration setting was introduced because the Microsoft...

This post describes how to strip off unwanted quotation marks around the character strings in the data file. Let’s assume that you have a text file which has the following data and you want to import the data into a SQL Server database table. “ ABC ”...

Environment : è Windows Server 2003 SP2 x64 è SQL Server 2005 Standard Edition SP2 x86 Build 9.00.3215 (SP2 with Cumulative Update 5) Objective : è To install SP3 for SQL Server 2005. Problem : è SP3 failed to install...

Problem Description =============== Not able to connect to SQL Server 2008 instance after applying SP1. Connection would fail with the following error TITLE: Connect to Server ------------------------------ Cannot connect to <Server...

We get the below error message when distribution agent tries to sync, Error: 14151, Severity: 18, State: 1. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. ...