SilverBack (4/29/2016)

---

There are no Dups in the original database as all of these are considered Key Values,

how would you begin to eliminate the dubs if they are key values.

Luis Cazares...

You might also consider whether or not you can use READ ONLY files / filegroups for the data they are reporting on. And if you can get rid of Excel...

Not that I'm aware of.

Chad Crawford (4/29/2016)

---

Reminds me of the strip that showed up on my Dilbert calendar this week: http://dilbert.com/strip/2013-04-25...

Grant Fritchey (4/29/2016)

---

Brandie Tarvin (4/29/2016)

---

So a coworker attended a gender diversity workshop. She forwarded me the presentation with a slide that says women constitute 40% of database administrators, the highest...

So a coworker attended a gender diversity workshop. She forwarded me the presentation with a slide that says women constitute 40% of database administrators, the highest of any computer science...

No. I meant it as a play on VLDBs as in Very Small Databases. But that's an interesting link. Thanks for posting it.

Lynn Pettis (4/29/2016)

---

Brandie Tarvin (4/29/2016)

---

Umm, that won't work. SSMS has the memory limitation. Not my desktop.

Per Microsoft:

Note SSMS is a 32-bit process. Therefore, it...

jasona.work (4/29/2016)

---

Grant Fritchey (4/29/2016)

---

Just a follow up on my other post (and apologies for bring tech & real work into the Thread, but you guys have the answers so I...

Okay. This is what I ended up with in order to make everything readable and easier to find the jobs I need to delete from the script. Also, I ran...

I have not counted. I have to pull them from several servers down to one or two scripts.

Umm, that won't work. SSMS has the memory limitation. Not my desktop.

Per Microsoft:

Note SSMS is a 32-bit process. Therefore, it is limited to 2...

Luis Cazares (4/29/2016)

---

Just to be sure, I like to use the quotename function.

SELECT 'IF EXISTS (SELECT 1 FROM msdb.dbo.sysjobs_view WHERE name = N' + QUOTENAME( name, '''') + ')

...

HA! Even SSMS agrees I have too many jobs. Using just a part of the code from Lowell's second link (to create the drop job stuff), I got

An error occurred...

Lowell (4/29/2016)

---

just the drops scripts are pretty easy, you can just build the statements from sysjobs;

select

'IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''' + name +...