Author Archives: uday arumilli

Download SQL Server 2014 – New features added in SQL Server 2014

Posted on July 22, 2013 by uday arumilli

Download SQL Server 2014 – New features added in SQL Server 2014 Microsoft Announced SQL Server 2014. I just came across through the below links. Download SQL Server 2014 CTP1 What’s New in SQL Server 2014 – MSDN   New … Continue reading →

Posted in Miscellaneous, SQL Development, SQL Server DBA | Tagged , , , , , | 3 Comments

SP_SPACEUSED is giving wrong counts

Posted on July 12, 2013 by uday arumilli

SP_SPACEUSED is giving wrong counts !!! SP_SPACEUSED: is a system stored procedure and used to capture number of rows, total size, data and index size information. Sometimes SP_SPACEUSED may give incorrect information or SP_SPACEUSED  give wrong counts. Below are some … Continue reading →

Posted in SQL Development | Tagged , , , , , , , , | 1 Comment

How to generate script for multiple objects in a database – SQL Server

Posted on July 10, 2013 by uday arumilli

Generating script for Stored procedures and views in SQL Server 2012 Today I have got a question from one of the beginner DBA. He was actually asked to get “CREATE SCRIPT” for 35 stored procedures and 15 views from one … Continue reading →

Posted in SQL Development | Tagged , , , , , , , , , | Leave a comment