SQL Server,C# and VB sharing Codes

14/04/2018

Hi guys! Give me your thoughts about Data model best practices.

12/01/2018

SELECT T.object_id
, T.Name 'HEAP TABLE'
FROM sys.indexes I
INNER JOIN sys.tables T ON I.object_id = T.object_id
WHERE I.type = 0
AND T.type = 'U'
ORDER BY t.name

Read this for more details. It will help you to boost your SQL Server Performance:

A heap is a table without a clustered index. One or more nonclustered indexes can be created on tables stored as a heap. Data is stored in the heap without specifying an order. Usually data is initially stored in the order in which is the rows are inserted into the table, but the Database Engine can...

16/11/2017

What are the difference between DELETE and TRUNCATE?. Answer will be posted later in the comment box.

04/11/2017

What is the difference between Mirroring and AlwaysOn

28/01/2016

05/05/2015

Goodevening Developers!
What is the difference between
DBA and DB Engineer? B-)

17/04/2015

Good morning everyone ! :) Inspire ourself to Develop more!

04/03/2015

Does anyone knows how to be a greate DBA :)

14/11/2014

Thanks for all your likes!! Please share

15/10/2014

Happy Cold morning everyone :)