Viewing 15 posts - 601 through 615 (of 2,763 total)
I'm presuming when you run it as a non-sysadmin, it throws an error of some sort?
What I might do is, because it's trying to hit the file system, is...
June 8, 2018 at 10:14 am
You know who I haven't seen posts from in a while?
The canine from Cardiff...
June 8, 2018 at 10:05 am
Sample code that people post in articles and the like is almost never going to be "production ready." It's simply there so that someone can see the *how* of doing...
June 7, 2018 at 12:24 pm
I know security items can be a PIA,...
June 7, 2018 at 11:41 am
Ugh. A requirement that recently popped up: "Thou must enable FIPS 140-2 cryptography!"
OK, sure, no probl...
OK, it's set to disabled by GPO and I can't change it.
"Thou...
June 7, 2018 at 8:49 am
June 7, 2018 at 7:26 am
I was told it runs faster when it's written like this:select ob1.name, ix1.name, ic1.index_column_id from sys.objects ob1 inner join sys.indexes ix1 on ix1.object_id = ob1.object_id inner join...
June 5, 2018 at 10:23 am
This looks like a variant of the adjacency list issue. Jeff...
June 4, 2018 at 12:34 pm
June 4, 2018 at 10:21 am
As every database is different, you may need / want to update statistics more frequently.
From the sound of it, you're not hitting the threshold for an auto-update, but...
June 4, 2018 at 6:47 am
May 30, 2018 at 2:04 pm
May 30, 2018 at 9:12 am
What does it say that, while I think I might know what the problem is, and I've already ginned up a solution and tested it, I'm not willing to post...
May 30, 2018 at 6:56 am
Viewing 15 posts - 601 through 615 (of 2,763 total)