Viewing 15 posts - 1 through 15 (of 1,831 total)
In truth, the account the procedure runs under doesn't even need
sysadmin
privileges (and I would suggest it shouldn't).db_backupoperator
is all it really needs to perform this task.
Just...
July 30, 2020 at 2:54 pm
another option is to use the great free tool SentryOne Plan Explorer:
https://www.sentryone.com/plan-explorer
It gives you a lot more information than the standard execution plan in Management Studio, including actual I/O,...
July 28, 2020 at 7:43 pm
And one more thing: Your dynamic query starts with UNION ALL... and that's going to cause a syntax error. Not sure why you have that in there, and maybe...
July 24, 2020 at 5:13 pm
I think the original SQL has some redundant parts in it, I believe it can be simplified to:
SELECT DATEADD(DAY, -8, DATEADD(WK, DATEDIFF(WK, 0, GETDATE()), 0));
Looking at the...
July 23, 2020 at 5:52 pm
This is great advice! All too many times I've seen commit messages that are generic like "fix" or something else fairly useless. The worst is if you work someplace where...
July 23, 2020 at 3:56 pm
I think you misunderstood what Grant was telling you to do. You can't create a VIEW inside of a PROCEDURE, just take your original query and put that in the...
July 23, 2020 at 3:17 pm
I have to admit many of the R or Python questions I get right are an educated guess, I don't really know anything about either of those languages. This one...
July 23, 2020 at 2:41 pm
ugh, I edited it and made it worse, so I went back to my original post, sorry for any confusion, but glad you found help from this.
July 23, 2020 at 2:25 pm
I think this would work best if you had a separate table already that had a list of asset_name and security_code values, but it looks like all you might need...
July 23, 2020 at 2:18 pm
Okay, maybe I misunderstood the OP, but I thought from their explanation of the problem that they were trying to use the TOP clause to only get part of the...
July 23, 2020 at 1:14 pm
...we renamed the new server to MyServer and the original server to MyServerOld... Then we got some error message in the new server's log
DESCRIPTION: Login failed for user 'mydomainname\myServerOld$',...
July 23, 2020 at 12:57 pm
You still never gave us what your answer was...
July 23, 2020 at 12:42 pm
In addition to everything Grant said, and he literally wrote the book on execution plans:
I'd also point out that the ORDER BY dufp.FeatureName will cause a sort to happen,...
July 22, 2020 at 8:46 pm
Salliven,
What is the error on the server side? Look at the SQL Server Logs in the Management folder of Object Explorer, or run a SQL command like:
EXEC...
July 22, 2020 at 8:38 pm
the easiest way to see how often OS is paging is looking at "Pages Input / sec" counter in the "Memory" section of Performance Monitor (perfmon)
July 21, 2020 at 8:13 pm
Viewing 15 posts - 1 through 15 (of 1,831 total)