Yeah, I get the same on 2014 Developer.  And I can't find any authoritative reference for the 100 row thing, either.  Hmmmm.

John

Yes, lack of statistics on table variables is likely to lead to inappropriate memory grants and inefficient plan choices.  Since SQL Server 2014, the query optimizer estimates the number of...

Try this:

WITH Factorials (Number, Factorial) AS (
    SELECT 1,       1 UNION ALL
    SELECT 2,       2 UNION ALL
    SELECT...

Absolutely.  I don't imagine the user is going to think any the worse of you if you tell him what you suspect the problem is but that you need to...

I can't explain why it runs quicker without the TOP 1000, but does he really need every column?  That must be an awful lot of data being dragged across the...

The only answer is to consult the documentation for the application, or raise a support call with the vendor.

John

Why don't use you just delete from the referencing table first?  Then you don't have to worry about disabling or enabling anything, and you can do it with little or...

Thom is right - a calendar table is the way to go.  You can use it again and again, and you can customise it with stuff like public holidays.  However,...

I agree with Gail.  Don't forget there are only two RDP connections to each server, and if someone wants to do some genuine maintenance work, they don't want to have...

Possibly a parameter sniffing problem.  Why are you staging the parameter values in @meter_table instead of passing them directly to the function?

John

Yes, you can do that.  Make sure you back up all your user database first, and script out important system stuff such as jobs and logins.  Bear in mind that...