Viewing 15 posts - 1 through 15 (of 227 total)
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...
November 3, 2020 at 3:10 pm
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...
February 24, 2020 at 5:19 am
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...
October 15, 2019 at 1:45 pm
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...
September 27, 2018 at 9:07 pm
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...
September 27, 2018 at 7:48 pm
July 16, 2018 at 7:32 am
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...
July 10, 2018 at 10:05 pm
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...
July 10, 2018 at 8:16 am
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),...
June 7, 2018 at 7:01 am
.
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...
June 6, 2018 at 8:44 pm
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...
June 6, 2018 at 8:41 pm
Resurrecting an old thread. January 19, 2018 at 5:02 pm
[AS principal] sets the grantor_principal_id in sys.database_permissions. As others mentioned, if the caller (a database_
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...
November 6, 2017 at 8:12 am
September 28, 2017 at 7:08 am
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...
September 19, 2017 at 8:31 am
Viewing 15 posts - 1 through 15 (of 227 total)