Viewing 15 posts - 1,786 through 1,800 (of 9,720 total)
Grant Fritchey (5/1/2016)
Jeff Moden (4/30/2016)
Grant Fritchey (4/28/2016)
I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to...
May 2, 2016 at 6:14 am
SilverBack (4/29/2016)
how would you begin to eliminate the dubs if they are key values.
Luis Cazares...
May 2, 2016 at 5:16 am
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...
May 2, 2016 at 5:10 am
Not that I'm aware of.
May 2, 2016 at 5:00 am
Chad Crawford (4/29/2016)
Brandie Tarvin (4/29/2016)
you can do anything you put your mind to.
Reminds me of the strip that showed up on my Dilbert calendar this week: http://dilbert.com/strip/2013-04-25...
April 29, 2016 at 3:23 pm
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
Viewing 15 posts - 1,786 through 1,800 (of 9,720 total)