Viewing 15 posts - 2,731 through 2,745 (of 22,214 total)
February 5, 2019 at 7:36 am
February 5, 2019 at 6:47 am
So... all those REPLACE things are going to prevent statistics use and index use and you're going to see degraded performance. Whatever structure is in place that forces that upon...
February 5, 2019 at 5:53 am
There are a bunch of articles right here on SQL Server Central that can help to get you started. This one right here seems perfect. Do a search...
February 5, 2019 at 5:50 am
I don't know of a complete course on this. I have several videos on my Youtube channel. I'll probably record more, but I doubt I'll ever do enough...
February 5, 2019 at 5:44 am
February 5, 2019 at 5:09 am
Ed Wagner - Thursday, January 31, 2019 12:49 PMExactly. You hit the nail on the head. 😉
Seriously? They lost five...
January 31, 2019 at 1:30 pm
Sounds like Rob Volk's awesome presentation, Revenge, The SQL.
Anyway, you need brackets on your database names in the code. It'll have to go into the...
January 31, 2019 at 7:05 am
The DDL triggers are a great idea (although I don't use SSIS and...
January 30, 2019 at 6:34 am
I'm actually exploring it. Having some login issues using Azure AD, but...
January 30, 2019 at 4:57 am
I have one app which usually keep checking for some reminder stuff and if find...
January 30, 2019 at 4:55 am
How is the SSIS package run? If it's run from within SQL Server, meaning it gets deployed to the instance (and this is not the way that most people I...
January 30, 2019 at 4:47 am
I agree with Steve's and Jeff's advice, but if this is HIPAA applicable PHI data, I'd stop providing that information right now. If you knowingly supply PHI data to unauthorized...
January 30, 2019 at 4:28 am
I remember reading about a new campus which intentionally did...
January 29, 2019 at 8:09 am
Viewing 15 posts - 2,731 through 2,745 (of 22,214 total)