I cannot count the number of times our developers have stated the "business logic belongs in the application". Our developers know there are multiple instanceS of our application, fronted by...

• This reply was modified 4 years ago by  SoHelpMeCodd.

The original design should have imposed a unique constraint on WorkLog.UserKey. Removing such a unique constraint (if done, in order to accommodate new design requirements) can have far reaching and...

• This reply was modified 4 years, 9 months ago by  SoHelpMeCodd.
• This reply was modified 4 years, 9 months ago by  SoHelpMeCodd.
• This reply was modified 4 years, 9 months ago by  SoHelpMeCodd.
• This reply was modified 4 years, 9 months ago by  SoHelpMeCodd.

If there is a natural candidate key and if you decide to use a surrogate key, test adding a unique constraint on a candidate key’s columns. Test using a simulated...

Amazon tells you to expect disasters and cluster your SQL Servers. For each of our SQL Servers we use AlwaysOn with 3 SQL Server instances, which is 1 below Amazon's...

I have not tried to repro (I don't have a mydb.dbo.mytable). Seems buggy. I see no enlisted distributed tran and I see no linked server. Have you tried simplifying this...

'A required Privilege is not held by client' is raised in a variety...

Sorry for the slow reply Steve.

Both tables are JOINed to a variety of other tables (~500 tables in the db). Their plans usually come with a high...

A well-written article about a knotty problem and a naughty design for an RDBMS. I am afraid the article's "let the DBA fix it" comments will earn this article a...

The Evaluation edition uses an Enterprise edition SKU, which is why the error is being raised. You need to backup your databases, script out jobs and other configuration changes (if any),...

.

If From BOL CREATE DATABASE (SQL Server Transact-SQL) topic

FOR ATTACH [ WITH < attach_database_option > ] Specifies that the database is created by attaching an existing set...

PLE uses a mean of a harmonic mean - see https://www.sqlskills.com/blogs/paul/page-life-expectancy-isnt-what-you-think/ (which discusses a customer situation with a similar concern to yours, and provides a better metric to observe...

Resurrecting an old thread.
[AS principal] sets the grantor_principal_id in sys.database_permissions. As others mentioned, if the caller (a database_

January 19, 2018 at 5:02 pm

#1976607

For such an EAV design I would expect the distribution of @TransactionParameterName values to be extremely variable. Some @TransactionParameterName values are likely to be singular, while other @TransactionParameterName values are...

There is nothing wrong with this approach. More for safety that for performance, I suggest backing up the clonedatabase and copying it off the production server, before flipping it back...