Question: When you delete data from a table, is SQL Server reducing immediately the size of that table? Continue reading Sql Server Interview question: Data deletion / Size reduction
Tag Archives: sql server 2005
How to determine what edition Microsoft Sql Server you have installed
To determine what edition of Microsoft Sql Server you have installed you have to start Sql Server Management Studio and run the following query : Continue reading How to determine what edition Microsoft Sql Server you have installed
How to avoid Select *
It is commonly known that you should not use SELECT * when you are writing a query.
Most of the times, we only need a some of the columns that a table has and we should retrieve only those columns.
This are some of the disadvantages of using Select * :
Continue reading How to avoid Select *