Viewing 15 posts - 586 through 600 (of 2,750 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
Viewing 15 posts - 586 through 600 (of 2,750 total)