a quick google shows me enterprise licenses for SQL2016 are $7,128 per core, so MSRP would be select 7128.00 * 16 = $114,048.00

At the PASS conference Glenn Berry noted...

it's a combination of being on the same subnet, and that sql instances that have the SQL browser service running.

the ODBC drivers poll the network for advertised services.

you can...

you can download it from the catalog:

start a new project File>>New>>Project

make sure you choose Templates>>Business Intelligence>>Integration Services>> Integration Services Import Project Wizard.

there you can choose the server,a dn then the...

typically something like this is due to an automated process, combined with not a lot of available disk space.

the dmv's will not be any help, as they are really run...

i'd say look at the SQL server error log first. see exactly what time, and what errors occurred. the error might point to something obvious.

compare that to your job schedules;...

great job on providing the set up!

i'm a little unclear on what the rule is for the gracemarks, though;

if they have a Practical_mark > 30, they get get a 70...

darn i missed this one.

day late, dollar short.

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic1838607-360-1.aspx...

A Calendar Table is really handy for this.

As an Inline calculation

the way i would tackle it is with DateMath, and a case statement that checks for Saturday or Sunday

here i...

Thomas makes a good paint on the procedures being the way the GUI makes job changes; that means besides triggers, you could also modify the procedures themselves so that they...

i think job changes are actually DML changes, and not DDL changes; those are insert/update/delete to the tables in msdb: dbo.sysjobs, dbo.sysjobsteps and dbo.sysjobschedules for example.

you could put DML triggers...

you need a master list of all employees to compare against;

then you can use an EXCEPT operator and your existing code

I would stick your results in a temp table,...

tocy1980 (11/18/2016)

---

I have tried this:

and it doesn't work.

Get this error: he multi-part identifier "Linked Servers.DATA STORE LINKED.'ET NEW$'.Parts Used" could not...

yes you can.

I think in 2012, you had to hand script everything, right?

i used the 2016 GUI, which shows the GUI filtering criteria , and then scripte dit;

hope this helps!

CREATE...

i googled a bit to find reasons SSMS is slow sometimes;

i see SSMS can sometimes validate some .net packages;

https://www.virtualobjectives.com.au/sqlserver/ssms_slow.htm

this one implies a few basics: virus scanners, the default connection type...