PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch
PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
Read MoreCategory: Internals
PASS 2015 – Seattle WA – Pre-Con Day 1 – Pinal Dave
PASS 2015 10-26-30 Seattle WA Pre-Con Day 1 – 42 Tips to Performance Tuning, Optimization and Everything Pinal Dave TODO: Write missing index…
Read More
Display all SQL Server’s Undocumented DBCC Commands
To 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 More
Resolving Failover Log-shipping errors
Here is an error I recent received when failing-over our databases at work from our Primary SQL Server to our Secondary during a…
Read More
Trace Flags for SQL Server 2012
DRAFT Here is a lot of info about SQL Server Trace Flags and their usage: Links Finding out who dropped a table using…
Read More
About Trusted Foreign Key Contraints
I will post some of my findings about trusted foreign keys and constants here since this has become a minor issue at work.…
Read More
Finding Suspect Pages
Here is where SQL Server stores any pages it has identified as suspect:
|
1 2 |
SELECT * FROM msdb.dbo.suspect_pages sp |
Views – 2321
Read More
Database Availability State Statuses
The possible values in the State and State_Desc columns of sys.databases are: 0 = ONLINE 1 = RESTORING 2 = RECOVERING 3 =…
Read More
Reseeding and Updating the INDENT_CURRENT Value in SQL Server
This code will do the following: 1. Display the current INDENT_CURRENT value for the identity column for the specified table. This value should…
Read More
DBCC command list
DBCC 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 More