Viewing 15 posts - 16 through 30 (of 96 total)
You haven't really given enough information for an answer. What does your TempDB look like (is it one file, what is the growth etc)? What free space do you have...
September 21, 2018 at 4:12 am
Don't know what Premium is as you give no context, so if its important, add it to the query, else:
IF EXISTS (SELECT 1 FROM BR_LIMIT_INSURANCES_TEST_TWO A INNER JOIN...
September 18, 2018 at 4:18 am
You can always build 2 new servers, call them what you want, turn on clustering, install sql, turn on always on, copy your database, then add a listener with the...
September 18, 2018 at 3:07 am
September 18, 2018 at 12:44 am
Using triggers for audit is fine, but they should always be kept simple and never nested, as soon as you start nesting or adding more complex code, you are asking...
September 12, 2018 at 2:29 am
Seek and you shall find..
July 30, 2018 at 2:42 am
July 26, 2018 at 2:14 am
No, what I am describing still gives me nightmares!
Think about it this way, every address has numbers that are repeated, every street has a name that is repeated,...
July 25, 2018 at 5:39 am
Normalisation has caused me no end of issues. I was contracted to a firm (I won't name them) to fix the slowness of a system they had had a massive...
July 25, 2018 at 2:45 am
I agree with the article, use the technology that is best for the purpose. In my last place of work, we used SQL to store and rationalise the data coming...
July 17, 2018 at 1:21 am
Firstly, congrats Steve, you deserve it.
As for tales on other MVPs, where I currently work, they brought in a PowerBI MVP as a consultant and they were clueless outside...
July 17, 2018 at 1:10 am
Why are you using sa? If you are connecting to the listener, why do you need to specify MultiSubnetFailover=true?
July 4, 2018 at 5:02 am
I wish to enable change data capture for a handful of tables, though I...
June 20, 2018 at 7:25 am
Set it to synchronous and automatic failover, just remember to have a script that will periodically copy users/jobs/credentials etc to the secondary.
June 13, 2018 at 1:21 am
Viewing 15 posts - 16 through 30 (of 96 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy