Nice things inside SQL Server, System Center Configuration Manager

Virtual Environment concept makes the virtual applications on the client to share the same file system and registry on client settings and share data among them. These Virtual Environments gets created on the clients whenever the virtual applications...

1. Surround With Feature This feature allows us to select a set of T-SQL statements and enclose them into Transactional, Conditional, & Looping etc. constructs like Begin-End, If-Else, & While etc. Steps: i) Open SSMS and open Query...

Customers have been asking for sequences for a very long time and now finally it is included with SQL Server Denali CTP 1. You don't have to do workaround of sharing identity table across all tables now. Creating a Sequence: CREATE SEQUENCE counter...

SQL Server 2000: CREATETABLE#TempTable ( [Index]VARCHAR(MAX), NameVARCHAR(MAX), Internal_ValueVARCHAR(MAX), Character_ValueVARCHAR(MAX) ) INSERTINTO#TempTable ...

SQL Server 2008 SP2 contains the following features: · All hotfixes released up to Microsoft SQL Server 2008 SP1 CU 8. · Updates to the Reporting Services Add-in for Microsoft SharePoint Products 2007 allowing customer to connect to...

i ) Open SQL Server Management Studio->View Menu-> Select Template Explorer-> Expand Database Mail in the Template Explorer->Select the 'Simple Database Mail Configuration' template it opens a SQL Server Template for database mail configuration...

To verify the SQL Server Express instance installed, you could use Microsoft SQL Server 2008 Setup Discovery Report. For more information, please see http://blogs.msdn.com/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx If the Setup...

Here are the following guidelines to increase performance during INSERT operation: 1. Inserting data into a table with a single clustered index is slightly better than inserting the same data into the same table with a corresponding nonclustered index...

Script: SELECT objectname = OBJECT_NAME ( s . OBJECT_ID ) , indexname = i . name , i . index_id , reads = user_seeks + user_scans + user_lookups , writes = user_updates , p . rows FROM sys . dm_db_index_usage_stats s JOIN sys ...

Download links for SSMS in 32bit and 64bit flavors. The full download of SQL Server 2008 R2 November CTP can be found here .

There are many ways to move/copy a database from one server to another server using SQL Server Tools. i) Detach the database from the old server and attach it in the new server. This is purely offline operation and it moves the database instead of copying...

You can use these docs for uninstalling your 2005 sql instance based on your requirement. Uninstalling an instance of SQL Server 2005 manually http://support.microsoft.com/?kbid=909967 Windows Installer Clean-Up Tool http://download.microsoft.com...

Introduction In the real world customer scenarios, the customer data can be of heterogeneous and semi structured stored inside SQL Sever tables. In such tables, the data can have different properties applying to different set of subsets of rows. In...

Prior to SQL Server 2008, the only way to audit the SELECT statements is to use SQL Server Profiler or server side trace. Now using SQL Server 2008 Enterprise, auditing feature is used to audit on SELECT statements. We cannot use triggers as triggers...

Data Compression in SQL Server 2008: The size of the databases are increased drastically due to - Movement of data from flat files into the databases due to east of management, accessibility, analysis and reporting. - Significant amount of data...

Introduction: This post describes a new feature in SQL Server 2008 – Grouping Sets The result set returned by GROUPING SET is the union of the aggregates based on the columns specified in each set in the Grouping set. Whenever an aggregate function...

What is Change Tracking? Change tracking is a new feature in SQL Server 2008 that allows applications to query for information about the changes that have been made to user tables since a previous point in time. Change tracking is intended to be used...