Inspect server and session User Options in effect
SQL Server can be configured to provide certain behavior to client sessions, via the SET OPTIONS= command, or via the sys.sp_configure ‘user options’ system stored procedure. The SET OPTIONS= command only affects the current session,…
SQL Saturday #837 Winnipeg – March 2nd 2019
SQL Saturday is coming to Winnipeg, for the 2nd time, on March 2nd, 2019 at the Red River Community College – Downtown Campus! SQL Saturday #837 Winnipeg should be a fantastic event; the last SQL…
Language used by the SQL Server binaries
SQL Server binaries come in various languages, such as 日本語 (Japanese), French, and English. It’s pretty easy to determine the language once SQL Server is *running*. A simple query does the trick:
|
1 2 3 4 |
SELECT sl.name , sl.alias FROM sys.syslanguages sl WHERE sl.lcid = SERVERPROPERTY('lcid'); |
However, if…
Query I/O over the Last Five Minutes
When faced with a SQL Server that is performing poorly, a great starting place for troubleshooting is looking at wait stats. Once you’re gathering wait stats, if you see lots of IO-related waits, you may…
How long since you ran DBCC CHECKDB?
If you’re not regularly looking for corrupt databases with DBCC CHECKDB, you’re putting your organization’s data at risk. I run DBCC CHECKDB once per day, or as is reasonably possible. Typically, DBCC CHECKDB is setup…
Index reorg/rebuild script
Index fragmentation may be causing more I/O than necessary for efficient query processing. Fragmentation occurs as a result of inserting items into the middle of the index instead of appending them to the end. Inserting…