I am sure what you wrote took a considerable amount of time to write. But I am afraid at least I cannot quickly determine a solution to your problem without...

An old article (one that I cut my teeth on :-D), but check out INF: How to Restrict the Inner Table of an ANSI Outer Join

Without knowing the before and after data types, and the DDL for the table, it is difficult to determine why a data type change required a table to be dropped...

One person's "slow" is another person's "fast" :).

If someone is able to define a "slow" period, collect dm_os_wait_stats close to start.

If someone is able to define when a slow...

The same approach (Scott's CROSS APPLY is faster than my JOIN, due to its use of DISTINCT) used for a City can be used for State. For State you can...

You are way too gentle Jeff. I struck out my comment - my apologies:)

If the points in the table are not ordered, or if the polygon's points do not adhere to the rules documented in https://msdn.microsoft.com/en-us/library/bb895267.aspx, or if a geography polygon's...

Slight rewrite of http://www.sqlservercentral.com/Forums/Topic1733134-3077-1.aspx

--declare @JobName sysname ='Your Job Name'

SELECT *

FROM msdb.dbo.sysjobs_view j

JOIN msdb.dbo.sysjobactivity a

ON (j.job_id = a.job_id)

JOIN (SELECT MAX(session_id) AS session_id FROM msdb.dbo.syssessions) s...

When the cost of a plan exceeds the cost threshold for parallelism, a parallel plan should be chosen (and cached). At run...

There are plenty of ways to collect perf data, with extended events being the future. But I am still using the old ways, at least for now. If on a...

My Windows DCs don't like my sqlservr's xp_loginfo (unrelated to this post), but thank you for the script.

A slight rewrite to avoid replace (and cast, somewhat):

IF OBJECT_ID('[tempdb].[dbo].[#TMP]') IS NOT NULL...

Yes you can

You would be able to get a better handle on aggregated durations by tracing the SP:StmtCompleted event and aggregating the results. Codeplex's pssdiag (using detailed template) and SQL Nexus can...

Gail's solution works, but it is similar to closing the barn door after the cow got out. Your application should not have been granted the ability to create logins -...

If the sqlservr.exe startup accounts have not been given the Lock Pages In Memory right, you can use Perform's Processes\sqlservr Private Bytes and ID counters. The Windows' process ID is...