PostgreSQL vs. SQL Server Notes
This blog will be where I post my PostgreSQL administration learning and it’s comparison to SQL Server from a SQL Server DBA’s viewpoint.…
Read MoreThis blog will be where I post my PostgreSQL administration learning and it’s comparison to SQL Server from a SQL Server DBA’s viewpoint.…
Read MoreI saw this in the SQL logs today. It looks like some corruption happened in the transaction log of a specific database. I…
Read MorePASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
Read MoreTo display SQL Server’s undocumented commands, you can run the following T-SQL:
1 2 3 4 |
DBCC TRACEON(2588); GO DBCC HELP ('?'); |
(use at your own risk, and not on a production…
Read MoreDBCC activecursors [(spid)] DBCC addextendedproc (function_name, dll_name) DBCC addinstance (objectname, instancename) DBCC adduserobject (name) DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)…
Read MoreHere is what to do when the tempDB log file runs out of space. You will not be able to run any sp_Who*…
Read MoreThis is a DBCC command I learned from Brent Ozar’s Indexing video. To get statistics on an index, simply use:
1 |
DBCC SHOW_STATISTICS ('Person.Person', IX_Person_LastName_FirstName_MiddleName); |
Views –…
Read More