SQL Server,C# and VB sharing Codes

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

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:

Heaps (Tables without Clustered Indexes) 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...

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

What is the difference between Mirroring and AlwaysOn

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

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

Does anyone knows how to be a greate DBA :)

Thanks for all your likes!! Please share

Happy Cold morning everyone :)