Dynamic SQL can be parameterised, and protecting against SQL...

You're connecting to the default instance, not the new one. When you specify a port number, you connect to the SQL instance that's listening on that port. If it's not...

Backup times are mostly from IO. If your backups have slowed down and the sizes haven't increased, then it's likely that the IO throughput on the IO subsystem has decreased....

You're welcome

Could you post the definitions of the procedures with IDs 263724042 and 594153212 in database 5?

Whoops.

Functions MUST be schema-qualified.

I suspect Kev did schema-qualify...

SELECT dbo.ufnGetAccountingEndDate()

Likewise. I need to spend tonight rehearsing...

1) Don't shrink data files without a good reason. It'll cause massive index fragmentation

2) Shrinking should be done only when something has resulted in a log/data file far larger than...

Cleared automatically meaning you're getting the cache flush messages in the error log? Or you're seeing the size of cached plans going to zero?

Providing the database doesn't contain persistent enterprise-only features (compression, partitioning, etc), then it is possible.

Please in future post new questions in a new thread.

Luis Cazares (9/16/2015)

---

You could meet halfway by doing something like this:

create procedure UberProc (@QueryId varchar(50))

as

if @QueryId = 'First Horrible Idea'

begin

EXEC OneProcedure @PossibleParameter

end

if @queryid = 'Second really...

Where are you seeing that SQL is only using 4 cores?

Kristen-173977 (9/15/2015)

---

ScottPletcher (9/15/2015)

---

Can't imagine why SQL would automatically issue a checkpoint just because an index is rebuilt. I have no idea whether a maint plan does or not, although,...

You'll have to change the name of Marketing before you can rename Marketing1. Even offline, it's still a database on the instance and database names have to be unique.