It sounds like you're getting different execution plans for the same query, depending whether it's run from SSMS or application. For clues about why, use the DMV script below to...

I see this responsibility (maintaining an inventory of Azure assets owned by the enterprise) falling under the umbrella of Platform Operations or Data Governance, not necessarily the DBA team. Not...

Yes, going forward, SPID and LoginName would be useful in the error log.

For now, if no one fesses up to the infraction, then perhaps hold all the...

Regarding the observation that the pace or quality of documentation often doesn't keep up with the pace of software development, one factor is that documentation is often left up to...

If you must do something like this, then at least automate it using a simple and tested script like the author provides. In the distant past, I've seen projects where...

What I've observed about SSMS 2016, since it was ported to VS framework, is that it takes longer to load and will occasionally freeze up. I'm guessing it has more...

Stupid SPAM doesn't even compile enough to form a complete a thought.

I have a database table containing one row for each MSSQL instance, and this table contains columns for physical environment, settings, capacity, etc. in addition to a description and the...