For test database refreshes the connections I kill are 99.9% idle as the app keeps connections eventhough no one is using the application.

Interesting.... I got this Kill SP from this forum years ago... I have never seen anything to the effect of do not kill SPIDs... except system ones obviously. I...

Create this stored Proc, run it as a step before your restore step. I use this to refresh NonProd databases all the time. The syntax for the kill...

Steve Jones - SSC Editor (11/28/2013)

---

Personally, I would like to see some of the salaries go down, or at least the years. It seems way more often than not the...

Cano may not get a 10 year 300 mill contact but to say teams aren't going to throw big contracts to players and 10 year deals are a thing of...

Since you are going from SQL2000 to 2008 you need to do a dbcc update usage.... also, at bare minimum run Update stats as SQL2008 handles indexes differently. Really...

Very nice script.

Not working properly is very generic.... errors..... slowness.... wrong results via query.......

What version of SQL Server and what service pack did you upgrade from and to.... also... be very specific...

If at all possible it is best to install SQL2008 on a new server and restore you dbs, jobs and users to it. In place upgrades are possible, however,...

The way I solved this is once the db is refreshed, add back what you need manually like via the GUI and script out the commands... then simply put those...

That is very bizzare. I have upgraded many dbs from 2000 to 2008 and never seen it change the attribute of a column....

Most applications have a configuration for their app pool connections...

like

Minimum number of connections, Max number of connections and sometimes a timeout if not used number.

Jeffrey Williams 3188 (9/23/2013)

---

Here is what I use:

Select r.command

, s.text

, r.start_time

,...

Try this:

USE MASTER

--

SELECT SESSION_ID, '[' + CAST(DATABASE_ID AS VARCHAR(10)) + '] ' + DB_NAME(DATABASE_ID) AS [DATABASE],

PERCENT_COMPLETE, START_TIME, STATUS, COMMAND,

DATEADD(MS, ESTIMATED_COMPLETION_TIME, GETDATE()) AS ESTIMATED_COMPLETION_TIME, CPU_TIME

FROM SYS.DM_EXEC_REQUESTS

--Apply this Where...

Take your time and go through each SQL Server and look at the databases, the jobs, the SQL Server log, run times of jobs, CPU usage etc... to get a...