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 5 years, 5 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 5 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...

have you used sp_send_dbmail before? i swear i've seen that error when the .net library 3.5 was not installed on the server, but dbmail depends on it:

December 6, 2019 at 8:14 pm

#3705542

i wrote a decent DDL trigger example for someone that had  a similar-ish requirement.

some people needed to be able to create ONLY views.

the solution was  arole,a nd a DDL trigger...

i think the issue is that on your new SQL2017 server, you must enable Filestream at the server level in SQL Configuration manager first.

then filestream would be supported. also, i...

this might be data related.

so far, lets say Word had to render x number or rows of text boxes, and now the data finally exceeds the number of objects word...

your insert statement above  is clearing inserting 820419145086 into the column in the very first line of the table, so your assumption that the column [NOKP_NEW] [nvarchar](255) NULL, will cleanly...

you can either  join the master_profile table  to the insert for the child table, or you can leverage the OUTPUT clause and capture the newly inserted data into a temp...

so looking at the code, it is using Excel Interop to save to a tab delimited file;

can you eliminate the middleman and just read the excel document with SSIS, and...

• This reply was modified 5 years, 11 months ago by Lowell.

that would only work on a very small environment right? I've got 64 prod servers and nearly 200 total including non-prod, and the number of times in the last year...