Why Use Dynamic SQL? You need dynamic SQL in the following situations: You want to execute a SQL data definition statement (such as CREATE), a data control statement (such as GRANT), or a session control statement (such as ALTER SESSION). Unlike INSERT,...
What is meant by Active – Passive and Active – Active clustering setup? List out some of the requirements to setup a SQL Server failover cluster? How do you open a Cluster Administrator? What are the differences in Clustering in SQL Server 2005 and 2008...
Index Scan When SQL Server does a scan it loads the object which it wants to read from disk into memory, then reads through that object from top to bottom looking for the records that it needs. Index Seek When SQL Server does a seek it knows where in...
What is Slipstreaming? It is a term used to describe merging original source media with updates in memory and then installing the updated files. Slipstreaming has been supported by Windows Operating systems for awhile but has just been added to SQL Server...
FILESTREAM FILESTREAMenables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. Applications can leverage the rich streaming APIs and performance of the file system and at the same time maintain...
The Simple recovery model if often used in testing and development environments, where data loss is not an issue. The older transactions are marked for reuse and will be overwritten with new ones automatically. In this recovery model, there is a little...
What is a SQL Server transaction log file? A SQL Server transaction log file is an integral part of every SQL Server database. Along with the data file, which has an MDF extension, the transaction log file with a LDF extension, makes a SQL Server database....
How to fix tempdb Full issue ? 1) Since tempdb recovery model is simple , Tempdb log will not grow drastically unless open transactions are there if so we will kill that spid and then shrink it 2) If mdf file is full we can shrink that but sometimes we...
What is blocking and how would you troubleshoot it? Blocking occurs when two or more rows are locked by one SQL connection and a second connection to the SQL server requires a conflicting on lock on those rows. This results in the second connection to...
Troubleshooting slow Running Queries in SQL 1) Whenever slow running query comes in to picture we will follow the following technique. We need to identify if this issue is at h/w or s/w level Most of the times the issue will be with SQL Server (s/w level)...
