How much Space can I expect to recover from a ...
In my last article – Identify Tables With Dropped Columns – we saw how we can identify tables […]
DBA
Identify Tables With Dropped Columns
In my last article – What happens when we drop a column on a SQL Server table? Where’s […]
Takeaways from Data Grillen 2024
Before anyone tries to order something online from DataGrillen.com and thinks it will be delivered by them by […]
What happens when we drop a column on a SQL ...
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable. But, most importantly – The […]
Different Ways to Populate the List of Tables
A database administrator has various tasks and responsibilities. Managing and keeping track of the database is one of […]
Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, ...
The post Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance appeared first on […]
Un « GREP » pour rechercher un motif dans tous les codes ...
Il est parfois nécessaire de rechercher dans toute l’étendue du code Transact SQL (vues, procédures stockées, fonctions UDF, […]