|
|
-
|
|
Most of the Developers / DBAs I have worked with are maintaining their utility scripts in file system. When ever a script is needed they browse through that folder via SQL Server Management Studio (SSMS) and open it. I have personally found this method little tedious and not so productive way of doing things. I always prefer these two methods instead:...
|
|
-
|
|
One of my office colleague recently asked me why we are not able to generate ALTER Table script from SSMS. If we right click on the table and choose "Script Table As" ALTER To option would be disabled or Greyed out. Is it a bug?...
|
|
-
|
|
In this post we would see one of the bad practices very commonly followed by developers which is risky as without our knowledge data would have got truncated before getting inserting into the table!...
|
|
-
|
|
If INT data type reaches its upper limit we can try to change the data type to BIGINT. But how do you know when BIGINT would also start overflowing?...
|
|