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)...
Prerequisites 1) Run upgrade adviser on the databases for the instance you want to upgrade. 2) If any issues are found, talk to your SME for fixing the same. 3)If issues are fixed proceed with the actual upgrade. -- Do check for the other dependencies...
Master Purpose - Core system database to manage the SQL Server instance. In SQL Server 2005, the Master database is the logical repository for the system objects residing in the sys schema. In SQL Server 2000 and previous editions of SQL Server, the Master...
Reading the SQL Server log files using TSQL This is a sample of the stored procedure for SQL Server 2005. You will see that when this gets called it calls an extended stored procedure xp_readerrorlog. CREATE PROC [sys].[sp_readerrorlog]( @p1 INT = 0,...
