Tag Archives: sql server

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

How to Use DBCC CHECKDB in SQL Server

Posted on June 26, 2013 by uday arumilli

How to Use DBCC CHECKDB in SQL Server Use: By far the most widely used command to check the status of your database is DBCC CHECKDB. This statement checks the allocation and structural integrity of all data and index pages … Continue reading →

Posted in SQL Server DBA | Tagged , , , , , , , , , , , | 2 Comments

SQL Server Architecture Questions and Answers

Posted on June 25, 2013 by uday arumilli

SQL Server Architecture Questions and Answers   Here are the list of Sql Server Architecture Questions and Answers which are asked in SQL Server developer / DBA  interviews Q. Can you draw SQL Server architectural diagram with all the components? … Continue reading →

Posted in Database Design, Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , | 60 Comments