[coding, debugging, and troubleshooting with Microsoft Technologies]
Translate This Page
Translate this page
Browse by Tags
Tagged Content List
Orphaned Locks - Idle Session - and XACT_ABORT
Sometimes you might see a situation where a session is holding locks, blocking other sessions for an extended period of time, but does not have an active request and appears to be Idle. This can happen in a few different scenarios, but here we’ll outline one scenario and how being sure to use XACT_ABORT...
8 Oct 2012
Sequence Objects in SQL 2012 and SQL 2008
Sequence Objects are new starting in SQL Server 2012. They work similarly to an IDENTITY value, but where the IDENTITY value is scoped to a specific column in a specific table, the Sequence Object is scoped to the entire database and controlled by application code. This can allow you...
8 Oct 2012
Finding Missing Dependencies
While working with a customer on a SQL port, I came across a system view that was new with SQL Server 2008. Have you ever needed to check your database code (stored procedures) to see if it references any missing objects? As of SQL Server 2008 this is easy thanks to: sys . sql_expression_dependencies...
22 Jul 2012
Loading data with foreign keys
Working on a customer project the other day, I needed to load some data into a database that had been scripted and re-created. The newly created database already had foreign keys in place which means for loading data (this was from SSIS), we had 2 options: 1) drop the foreign key constraints...
15 Jul 2012
How can I get a list of installed SQL Server instances?
Today we’ll talk about how we can get a list of locally installed SQL Server instances on a system. This information is stored in the registry at the following location: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL EDIT: If you are looking for 32 bit instances...
11 Oct 2011
Searching through the SQL Server Errorlogs
Sorry – It’s been a while since my last post. The past few months have been very busy for me. The other day, I had a brief discussion with a colleague on ways to search through all of the error logs in SQL Server. Obviously there are a few ways to do this – through PowerShell, simple...
10 Oct 2011
Page 1 of 1 (6 items)
© 2013 Microsoft Corporation.
Privacy & Cookies