A simple script to know how much space the tables are taking from the disk. SELECT t.name AS TableName ,
Update data in SQL Server is a simple task. Using the command update table set column = value where column
I like tools and I’ve used a couple of them. I had the opportunity to try SQL Examiner to compare
The first checklist before start using any application using SQL Server should be the default configurations. What configurations I used
SQL Server has many undocumented functions and commands. I will write series of posts with functions to have a library online.