Category Archives: SQL Development

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

Difference between NEWID() and NEWSEQUENTIALID() in SQL Server

Posted on July 9, 2013 by uday arumilli

Difference between NEWID() and NEWSEQUENTIALID() in SQL Server Both NEWID() and NEWSEQUENTIALID() are used to generate GUID of data type UNIQUEIDENTIFIER in SQL Server. The Basic difference between them is NEWID() generates GUID’s in random order whereas NEWSEQUENTIALID()  generates GUID’s … Continue reading →

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