Debates over primary keys and clustered indexes never get old.

Code compilation isn't much of an issue in my realm. However, if a user runs a query that joins two or more billion row tables using a non-indexed expression and...

... This is attributed to the user clicking the operation, waiting a bit for a response, and when one was not presented, clicking the button again. I know what...

There is no compelling reason to avoid cursors and dynamic sql when you're doing something like coding an administrative script that is occasionally used to iterate across databases or servers....

You might as well disable the login until the application is fixed.

A lot of application developers only work with transient persistence layers, something like session state for an embedded application or the shopping cart for an eCommerce website. In that case,...

I'll bet Google knows exactly where Steve is, right this minute. They know where he was exactly one year ago, and they probably have an algorithm that can predict where...

Perhaps start with the AdventureWorks sample database, and then extend it by modeling additional tables for Payroll or Invoicing.

Some people may (even subconsciously) be using their work life as an escape from home life.

... The news cycle seems to be dominated by discussion of politics. Regardless of where you fall on the political spectrum, the talk of politics is inescapable and is...

Thanks for finding what tables contain the catalog permissions. Based on this I'll code up a script to generate GRANT_PERMISSION statements from SSISDB. There should have been a way to...

First, is the workload on the new server the same as what was typical on the old? Also, list and compare the server level settings between the new and old...