Microsoft Technology

Today, one of my colleague asked me, how to generate a Script for a table-schema as well as data-Schema? Whatever I explained to him, I th...

The following table shows what is the maximum size/number of objects can be created/Used in DB Engine by thru wizard or by T-SQL Statemen...

Overview:- Microsoft Released the CTP version of SQL Server 2008 Service Pack 3 (SP3), It is available at,  http://www.microsoft.com/downlo...

The data which are storing in the table are structured data, because we organizing the data in proper way. but most of the data are unstruct...

Reference: http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx

SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. ...

In My Previous post " PIVOT Operator in SQL ", I explained about, How to use T-SQL Operator PIVOT. http://blog-mstechnology.blog...

This Article, helps to start a windows services thru SQL Script. To control the windows services, we can use SQL Server’s Extended Stored P...

Today I’ve created a new table using SQL Server Management studio 2008, it creates successfully. When I try to write a Query using this ta...