in order to keep things ATOMic, nolock is ignored in INSERT/UPDATE/DELETE operations.

even if you added it, it would be ignored.

Well for MaxDop recommendations, I've been using this pair of scripts  which have  calculations that someone else came up with.

this script takes into account numa nodes and microsofts recommendations, and...

multi-threading is completely unrelated to how SQL server internally uses multiple cores.

a multi threaded operation is how the applciation does it's thing, SQL server is a black box as far...

sys.dm_db_index_usage_stats already has all the index usage for all databases and all tables inside it, so you can get all the Databases all at once. no need for a loop...

• This reply was modified 4 years, 3 months ago by  Lowell.

you would need to add some code to specifically stop execution in the loop if an error is encountered.

you might want to change the logic to be all-or-nothing, instead of...

it looks to me like you declare one variable, but use one that never existed a few lines later:

i think you declared "SQL", but dynamically create "strSQL" a few lines...

I hope this example helps.

in this case, i am looping through all *.sql files in a given folder.

the output to a log file creates a  set pf Starting $scriptname /...

Thanks Jeff, I think my script is fine though, I don't think a unique index that is not part of a constraint requires any additional logic or exceptions.

a unique index...

• This reply was modified 4 years, 6 months ago by  Lowell.

well i remember a time where we used to provide scripts, and then an explanation of what not to do....

try my flavor of unused indexes. don't blindly execute them, evaluate...

going forward, you could add something like this extended event as an example.

assume you want to track what [mydomain\IzaguirreL] is querying.

you don't need to identify the domain, as that is...

• This reply was modified 4 years, 6 months ago by  Lowell.

without already having added something specifically to capture that, like an old-style  trace or the current incarnation of capturing via extended events, then no, it is not possible to find...

Dan, rather than use the >  redirect, I've been using | Out-File with the Append parameter, and it works flawlessly for me: i return info messages, data sets etc, dividers,...

• This reply was modified 4 years, 6 months ago by  Lowell.

upgrade your SQL Server Management Studio to the latest 18.3 or above..

versions 17 through at least 17.5 did not handle browsing cubes against 2014 correctly.

https://developercommunity.visualstudio.com/content/problem/167945/the-tabular-view-feature-is-not-included-in-the-64.html

for a definition of decimal(10,5):

10 = maximum number of digits.

5 = number of digits to the right of the decimal point.

that means the largest value allowed before an error would...

you have two FROM statements; it treats the inner FROM as an accidental cross join; i think if you simply remove it you get the results you would expect.

this is...