hmmm ... with an active passive cluster with 64 GB of RAM the largest paging file you should have configured is either 16 or possibly 32 GB. With 99% page...

what credentials are you using on this SQL Server ? are you in the 'sysadmin' role ?

is the server really busy ?

have you tried running the query from SQLCMD ?

silly questions:

was there a maintenance outage or down time ?

do you have the SQL Server errorlogs available ?

does your job produce an output log file ?

have you scanned the application...

Do not 'over provision' - SQL does not like having memory and/or CPUs managed in and out.

Most applications can handle that but SQL Server really, really hates it.

In looking at...

hmmm ... I am thinking network related here.

Have you looked at your network configuration on that server ? possibly a bad DNS search order ? or even an non-existant DNS...

The question was cute - the correct answer is unfortunately 'obtuse' code that really has no place in a production environment.

think "Code with clarity" ...

I would also look at database size, CPU load and potentially using the Resource Governor to keep normal SQL Server performance levels within acceptable ranges.

These are Windows Server vulnerabilities methinks - these and any other MS security hot-fixes should ALWAYS be applied.

Not at all since our SQL VM instances have resources that are fixed.

We only 'over provision' WEB, Citrix and aplication servers - NEVER SQL Servers.

Our environment is 80% virtual (550+ SQL server instances).

A previous point alluded to about SQL Server not playing well with 'others' is just not true.

SQL Server does not like having...

What is wrong with table variables ?

hmmm ...

table variables are not capable of having indexes (however they support constraints and primary keys)

no indexes mean:

- no index statistics...

A great list discussion - my 3 cents:

- table variables need to be depracated with extreme prejudice

- SSMS generated code (IMAX screen width anybody ?)

- UpperLowerCase as...

First a few questions:

- Is the server physical or virtual ?

- Is there an application on the database server ?

- How much RAM is on the server...

Call me 'old school' - a single 24" monitor in the office and a single 22" monitor at home.

I never open up more than 24 applications at a time (3...

WOW - 2005, 2007, 2011, 2014 - what a thread life !