Viewing 15 posts - 3,361 through 3,375 (of 4,477 total)
What do those script do? Are they t-sql scripts that run on a database local to that server or do they do something else?
Are they...
July 11, 2017 at 6:34 am
The path you are showing is correct - the registry entry is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<Instance>\MSSQLServer
But as John said, your screenshots don't show. Usually you right...
July 11, 2017 at 6:25 am
July 10, 2017 at 4:50 pm
July 10, 2017 at 2:41 pm
1. You could try denying select on the views database_prinicipals and database_role_members. That will prevent the users from seeing those but I'm not sure if it introduces...
July 10, 2017 at 1:42 pm
You might also want to look at the ExecutionLog3 view to see where the time is being used - that can often give you an idea on...
July 10, 2017 at 11:35 am
Hopefully someone can shed some light on this. I have been tasked to...
July 10, 2017 at 11:19 am
It's the nulls for the majority. In addition, you get the incorrect values as you aren't calculating your days column the same as the case statement.
July 10, 2017 at 10:26 am
You have a few million rows in your backup tables for the history. If you don't run regular maintenance on msdb, this can happen.
Why don't...
July 9, 2017 at 2:49 pm
I know that SELECT COUNT(*) FROM table name will return the total number of...
July 6, 2017 at 8:31 pm
I have created a pretty intricate report that a client uses for invoicing their...
July 6, 2017 at 10:59 am
July 6, 2017 at 7:27 am
SQLCAT had several articles related to this - they moved those into an eBook. Check section 5 in the BI and Analytics ebook which you can download...
July 5, 2017 at 5:08 pm
Ihave a report that produces a bar chart. This chart lists...
July 5, 2017 at 3:12 pm
Maybe try checking the plans using dm_exec_plan_attributes - it can be easier to find differences using this DMV.
Sue
July 5, 2017 at 1:56 pm
Viewing 15 posts - 3,361 through 3,375 (of 4,477 total)