Viewing 15 posts - 1,786 through 1,800 (of 9,715 total)
Grant Fritchey (4/29/2016)
Brandie Tarvin (4/29/2016)
April 29, 2016 at 12:08 pm
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...
April 29, 2016 at 11:47 am
No. I meant it as a play on VLDBs as in Very Small Databases. But that's an interesting link. Thanks for posting it.
April 29, 2016 at 11:14 am
Lynn Pettis (4/29/2016)
Brandie Tarvin (4/29/2016)
Luis Cazares (4/29/2016)
Or install more memory.
Umm, that won't work. SSMS has the memory limitation. Not my desktop.
Per Microsoft:
Note SSMS is a 32-bit process. Therefore, it...
April 29, 2016 at 10:47 am
jasona.work (4/29/2016)
Grant Fritchey (4/29/2016)
April 29, 2016 at 10:46 am
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...
April 29, 2016 at 7:59 am
Eirikur Eiriksson (4/29/2016)
Out of curiosity, how many jobs do you have?😎
I have not counted. I have to pull them from several servers down to one or two scripts.
April 29, 2016 at 7:51 am
Luis Cazares (4/29/2016)
Or install more memory.
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...
April 29, 2016 at 7:50 am
Luis Cazares (4/29/2016)
SELECT 'IF EXISTS (SELECT 1 FROM msdb.dbo.sysjobs_view WHERE name = N' + QUOTENAME( name, '''') + ')
...
April 29, 2016 at 7:39 am
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...
April 29, 2016 at 7:15 am
Lowell (4/29/2016)
select
'IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''' + name +...
April 29, 2016 at 6:55 am
So I had my dose of mild frustration followed up by a funny this morning.
A dev asked me to restore two Test 2012 databases down to SQL 2k8. As I'm...
April 29, 2016 at 6:47 am
I think I found what I needed. I will know when I've tested it.
From BOL on Integration Services job steps:
Use 32 bit runtime
Indicate whether to run the package...
April 29, 2016 at 6:21 am
Can someone help me with "hacking" the Script Job As Drop code?
I don't really want to hack MS's version so much as look at it and adapt it to my...
April 29, 2016 at 5:35 am
Eirikur Eiriksson (4/29/2016)
BLOB_EATER (4/29/2016)
GilaMonster (4/29/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
April 29, 2016 at 5:34 am
Viewing 15 posts - 1,786 through 1,800 (of 9,715 total)