With the exceptions of indexes created as part of a primary key or unique constraint, then no. SQL does not save the creation/modify date of indexes. you can get the...

this page specifically says, for SQL 2012, no retirement for exams are planned at this time:
http://blog.firebrandtraining.co.uk/2017/01/microsoft-exams-retiring-2017.html

SQL Server

As with SharePoint, we see only the planned retirement...

you are correct.
SSAS can participate in a Cluster with shared storage, and is Cluster Aware.
but  the service does not  have the equivalent of Availability groups.

don't test on production.
best practice is to test on a Development copy of production,s o you have no chance of actually screwing up important data.
never test on production.

yeah now that we see the actual execution plan, we can see the impact of the nested views; there's a couple of tables like [ins_smr] and [ins_mod] that are joined...

for me, your expression looks like the problem, but of course it depends on your data.
=IIf(Fields!NotificationType.Value = "Discharge",False,True
that is evaluated each row, right? so potentially some rows toggle...

I'd look at the indexing and SQL code in the view; it could be using non-Sargable WHERE statements or join criteria, inline scalar functions, or just not have any indexing...

create a table with the same schema as the table you want to audit.
add additional columns for capturing whodunnit information.
then you just need a trigger to handle update...

somone already mentioned that the order by , when inserting into a table is an extra cost with no benefit;(a table has no implicit order...you have to use an order...

here's your data setup with proper data types. your monthYr MUST BE a date datatype in order to get the proper order. you don't want the data to order in...

Nice job Theo;
I had created a procedure to check the current patch version,all available patch version, and the suggested Service pack version, but it used an internally contained CTE full of...

what you want is a case statement to pick one column or the other base don the value.
here's a complete working example based on what you posted. see how...

look specifically at the path in that Package.ConnectionManagers[StaffExport], 
is it using a mapped drive, and not a unc path? ie the path should be \\servername\sharename\filename.txt, and not the T:\sharename\filename.txt
mapped...

I have a DBA_Utilities database that I keep tables  in place for randomization. So for example i have a MovieStars database that is a cross join of Real Movie Starts...

Analysis server allows windows connections only, you are correct.
i those situations, we've added consultants to have a domain name on our network, and they connect via citrix to establish...