How are temp tables created inside tempdb, even when sessions use the same name? My look inside temp table object creation, with a quick metadata check.
SQL SERVER – Maintenance Plan – Maintenance Cleanup Task not Deleting Files
A reader’s Maintenance Cleanup Task reported success but old .bak files were never deleted. The maintenance plan log files helped us find the cause.
SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run
After a backup restore mistake, SQL Server would not start and ERRORLOG said the database ‘model’ is marked RESTORING. This is how I got it running again.
SQL SERVER – SSMS Trick – Generating CSV file using Management Studio
Readers asked why use SQLCMD or BCP at all. Generating CSV file output is easy in SSMS: set Results to Text as comma delimited in Tools, Options.
SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10
Want to plot your own values, like rows in a table, next to standard PerfMon counters? The procedures sp_user_counter1 to sp_user_counter10 do just that.
SQL SERVER – Common Sense Data Security – Notes from the Field #055
Kevin Hazzard explains common sense data security for sensitive user information, with humor and real world examples you will recognize.
SQL SERVER – Is tempDB behaving like a Normal DB?
TempDB is a special shared database, but in many ways it behaves like a normal DB with a twist. I share how I explained it to DBAs during my tuning work.
SQL SERVER – SQLCMD to Build Comma Separated String
A trick from Balmukund and Vinod at SQLBangalore: use SQLCMD to export a table’s data as a comma separated string. Here is how it works.










