SQL Server 2012 launch virtual online event on 7th march 2012. For more details http://www.sqlserverlaunch.com/WW/Home

I just learned one new thing today."How to get spatial index details with using T-SQL" check out following query. Method #1 [code] SELECT a.name AS Table_Name,b.name As Index_Name FROM sys.tables a INNER JOIN sys.spatial_indexes b ON a.object_id=b.o

I just learned one new thing today"how to know which database is used for tuning." check out following query. [code] USE MSDB GO SELECT * FROM DTA_reports_database GO [/code] Result is: [code] DatabaseID SessionID DatabaseName

I just learned today one new thing, Database Tuning Advisor(DTA) related tables and stored procedures stored in MSDB Database.

I just learned today new thing,"How to delete old e-mail messages from database mail internal tables with using sysmail_delete_mailitems_sp" check out following query. [code] USE MSDB GO Exec sysmail_delete_mailitems_sp @sent_before ='2011/12/14',@sent

I just learned today new thing, "How to know all database mail details like subject,body,recipients,CC,BCC,status,send date,file attachment etc.information with using catalog view sysmail_allitems." check out following query. [code] USE MSDB GO SELECT

SQL Server release History: [code] Version Year Release Name Codename ------------------------------------------------------------- 1.0 (OS/2) 1989 SQL Server 1.0 (16bit) - 1.1 (OS/2) 1991 SQL Server 1.1

I just reviewed sys.dm_db_partition_stats DMV for retrieving no. of rows exist in table,check out following query. [code] CREATE TABLE testdemo--Create sample table (id int identity, name varchar(20)) Go INSERT INTO testdemo VALUES--Insert samp

Microsoft has released cumulative update packages for both SP2 and SP3. 1. Cumulative update package 7 for SQL Server 2008 Service Pack 2 2. Cumulative update package 2 for SQL Server 2008 Service Pack 3 For more details see: [code] http://suppor

I just learned one new thing today,you cannot create snapshot of the system databases MASTER,MODEL and TEMPDB.you can create snapshot of MSDB database with following query. [code] CREATE DATABASE msdb_Snapshot ON (Name = MSDBData,--Database logical na