SQL Server – Service did not respond in a timely fashion – Start-up Parameter changed

Every time, Sql server starts it looks for master database that act as heart of sql server engine without master database, Engine will stop working. Lets check whether sql server will come up without master database or not. So for this, we made some changes in log file location of master database using start-up parameter ...

SQL Server Error-Fix-failed to install and configure assemblies (Microsoft.sqlserver.MSMQtask.dll in the COM+)

We plan to upgrade the sql server 2005 x32 bit to x64 bit. Before starting, we wanted to uninstall the existing version of the sql server and then plan to start the installation of new sql server version in 64 bit on existing hardware. We checked all perquisites before applying new version of sql server like ...

Model database in sql server

As we know model database acts as a template for other new databases which are gets created on sql server. That means if I do any changes in model database that will reflect in the new database of sql server.  Lets go through with small example to understand this feature better.  In SQL Server 2005, ...

Find slow running sql query in sql server 2005

Slow running sql query on production server with sql server 2005 We got a request from users saying that sql query is taking too much time to execute. Normally it returns the result set less than 15 minutes now it taking more than 30 minutes to generate output. We checked the active sessions on the ...

SQL Server Page and Extents

Sql server Page is fundamental unit of data storage and allocated in data file. Data file is logically divided into pages starting from 0 to n, SQL Server reads and writes operations are performed at the page level. The collection of eight contiguous pages are known as extents i.e. 1 extent = 8 pages. All ...

What is Difference between nchar and nvarchar

nchar and nvarchar are indicates that it will store Unicode characters whereas char and varchar can’t store Unicode characters. Char and nchar are fixed-length datatype. Fixed-length datatype that means it will occupy space whatever number you have specified at the time of table definition. Even if you don’t use all that space. Varchar and nvarchar are Variable-length ...

How to use CTE in SQL Server 2005 15

Common table expression acts as temporary result set for the query (select, insert , delete and update or merge). It can be use as derived table for storing result set and while joining with different tables. CTE doesnot act as object and scope is limited to till query execution.  Can be use as alternative option ...

SQL Server shortcuts on keyboard

Fruquently we use number of commands while working with sql server for our day to day activity  like sp_helptext, sp_help, sp_who , sp_locks and many more. Instead of keeping all these commands in mind, we can create shortcuts on keyboard for sql server 2005. How to create sql server shortcuts on keyboard? In sql server, we can configure these shortcuts ...

How to rename table column in sql server

One day in office, we were working with team for application testing. Suddenly we asked to rename the table column using t-sql command. In sql server, we can use sp_rename command to rename table, sp and column in database. Using below script you can change table name or column. sp_rename ‘tablename.[old_column_name]’, ‘New_column_name’,’Column’ example : if we want to ...