script for insert data sql statement

Some times we need insert into select statement for tables from one database to other database. Here is the script which will create the script for this process.

How to get size info for database file using dbcc showfilestats

CREATE TABLE freefilespace
         fileid       INT,
         filegroup    INT,
         totalextents INT,
         usedextents  INT,
         dbname       VARCHAR(256),
         filename     VARCHAR(2000)

Undocumented Commands

Note:-All the samples here are run against AdventureWorks sample DB

DBCC proccache

Provides procuedure cache information

lets play with XML

Here is Nested XML which contains data from 2 tables ,Customer and Order
I want to get data for this 2 tables from XML

Amazon Contextual Product Ads

Popular Posts