Viewing 15 posts - 9,871 through 9,885 (of 39,769 total)
Lynn Pettis (3/30/2015)
March 31, 2015 at 8:35 am
Xavon (3/31/2015)
But it's...
March 31, 2015 at 8:33 am
I really like Grant's idea here of Log Shipping to continue to test and keep your new system close to the old one.
I'd follow his steps
March 31, 2015 at 8:31 am
Greg Edwards-268690 (3/31/2015)
GilaMonster (3/31/2015)
Yet Another DBA (3/31/2015)
March 31, 2015 at 8:30 am
Yet Another DBA (3/31/2015)
Steve Jones - SSC Editor (3/30/2015).... . Developers shouldn't have access to account information or keys that are used in production. There should be separate credentials used...
March 31, 2015 at 8:18 am
True, but not everyone starts in a small shop. Plenty of people change jobs, and the more we apprenticed, the more talented people that would move on to other positions.
I...
March 30, 2015 at 12:58 pm
It's only to let someone easily cut/paste code and exclude the semi-colon.
I do try to provide good code samples with semi-colons in them to help get people in the habit.
March 30, 2015 at 12:54 pm
Jeff Moden (3/27/2015)
BWAAA-HAAA!!!!! SPAM REPORTED!!! 😀
Ha, you're jealous because I ignored Detroit.
March 30, 2015 at 12:37 pm
Koen Verbeeck (3/30/2015)
Such a bad habit to start a CTE with
;WITHI hate it 😀
Nice question though, thanks Steve.
I agree. I've started to try this:
;
WITH myCTE ...
March 30, 2015 at 12:35 pm
Wayne West (3/30/2015)
March 30, 2015 at 9:28 am
lshanahan (3/30/2015)
Heck, I'd kill for some kind of apprenticeship/mentoring program. I'm perfectly comfortable hacking all this out on my own, but I know there's AN AWFUL LOT I'm missing.
Ditto.
BTW,...
March 30, 2015 at 9:25 am
One other thing, perhaps you can do a simple "switch" for your table. Rename your table before print jobs are generated and recreate a new, blank one. Then you can...
March 30, 2015 at 9:24 am
Concur with Grant's explanation.
Here's what I'd look at. Do you create an hour's worth of data every day? Or any day, maybe is a better question? Could you schedule the...
March 30, 2015 at 9:23 am
I haven't done this specifically. Only 2005-> 2008 and R2, so bear that in mind.
There is an upgrade advisor you can run from 2014, which will tell you potential issues...
March 30, 2015 at 9:14 am
And I didn't respond last weekend because I bought this:

March 27, 2015 at 5:51 pm
Viewing 15 posts - 9,871 through 9,885 (of 39,769 total)