Using the ScriptDom without losing comments

The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...

Calculating Table Partition Sizes in Advance

[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 7. The partitioning includes several major components of work (and can be linked...

Calculating Table Partition Sizes in Advance

[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 7.
The partitioning includes several major...

Using multiple log files

The transaction log is made up of one or more files that are used sequentially. So in other words if...

Cumulative update package 9 for SQL Server 2012 SP2

Microsoft just announced Cumulative update package 9 for SQL Server 2012 SP2

Microsoft reference: [Click Here]

For more updates:
Subscribe for Blog posts [Click Here]
Follow...

Steps to install SQL Server CTP 3 on Windows Azure

Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...

SSDT DevPack - Highlight expensive queries

When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...

SSDT DevPack - Highlight expensive queries

When developing stored procedures in SSDT it is important to know when you have written a query that is potentially slow or has a high IO or CPU cost...

SSDT DevPack - Highlight expensive queries

When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...

SSDT DevPack - Highlight expensive queries

When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...