I apologize greatly if I'm just blind and am missing it, but I don't see where the database is specifically mentioned within the stored procedure. Where exactly would you...

Satiz (4/8/2016)

---

Thanks for your reply .I need to change this dynamically because database name differs in both staging and production environment so we will passing database name as a...

I have personally read a lot of good articles on this topic (many from sqlservercentral.com itself). One of the things I've learned is to first ask the question, "Do we...

(Edited) Reply moved to the other thread

In our organization we are 99+% virtual in our North American region. Currently our environment is all company-owned assets in a third-party data center, but we do have...

12 SQL core licenses

11 efficient indexes

10 replaced cursors

9 replaced cursors

8 replaced cursors

7 replaced cursors

6 properly terminated loops

5 SSDs

4 Red Gate tools

3 deterministic functions

2 more days off

and a tally table just...

First of all, consolidation of SQL servers (especially physical ones) can provide several large benefits ranging from reduced licensing costs to simplifying administration. Upgrading to a newer version also...

This doesn't explicitly answer the question, but it is something you can consider. I keep a CALENDAR table in many of my databases. It can be customized to...

You're not going to reduce the size of the MDF without a SHRINK operation. And on a data file, that can (and most likely will) cause performance degradation, therefore...I...

Personally, the first thing I'd do is find out why it grew like that. Was a large table deleted? Indexes changed, removed? Are there tables in there...

SQL Server will only execute one instance of a job at a time, so the loop will try to execute the same job multiple times without waiting for the first...

If by "saved in the database" you're referring to storing it MSDB rather than as a file system object or in an SSIS catalog, then all you really need to...

/raises hand

I second that "AAAAAARRRGH". I'm responsible for maintaining a web site that basically runs Crystal reports against...

This one was YEARS ago and I'm still not sure how funny I consider this one, but I'll certainly never forget it! Our devs were building a web site...

I ran into this issue today and confirmed that the detach/reattach or offline/online switch works for current SQL versions as well (SQL 2008 R2 in this case).