Viewing 15 posts - 1 through 15 (of 225 total)
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. [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
January 19, 2018 at 5:02 pm
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
Before following this tip, review the bootstrap folder and strive to determine why the upgrade failed. If you cannot determine why the upgrade failed, the advantage of reinstalling the operating...
September 18, 2017 at 7:13 am
Did a human kill CHECKDB or was CHECKDB unexpectedly killed by a high severity error that was raised to SQL Server's errorlog?
If the latter, you need to inspect...
June 27, 2017 at 8:38 am