Viewing 15 posts - 1 through 15 (of 26 total)
frederico_fonseca (10/20/2016)
All databases on DEV/UAT/FIT are named as follows
XXX_YYY_999_databasename
where XXX is one of DEV/UAT/FIT
YYY is the developer code/name
999 is the project being...
October 22, 2016 at 5:25 pm
Grant Fritchey (10/19/2016)
October 20, 2016 at 3:37 am
Phil Parkin (10/19/2016)
mark 4643 (10/19/2016)
Our dev team is growing. We use red-gate toolbox, so we have schema compare, data compare and source control. for the past few years we...
October 20, 2016 at 3:33 am
Jeff Moden (9/17/2014)
September 19, 2014 at 11:52 am
Thanks Eugene
Worked great. Yeah it is bit of strange definition, but it's the spec I was given
September 17, 2014 at 4:48 pm
serg-52 (9/17/2014)
Cannt figure out why jobs 5 and 7 are to be in the result set while they overlap with job 2.The query must ignore overlapping when ... what?
Sorry, I...
September 17, 2014 at 7:27 am
thava (4/17/2014)
;WITH cte AS
(
SELECT ROW_NUMBER() OVER ( ORDER BY ResourceID, dt) AS Rno,
x.ResourceID, x.JobNo, Dt, xdt.Type
FROM ...
April 18, 2014 at 6:21 am
dwain.c (11/6/2013)
There may very well be an easier way to do this, but this is what I came up with:
Thanks!
I had played around with a derived table and a cross...
November 7, 2013 at 7:59 am
dwain.c (11/6/2013)
November 7, 2013 at 7:52 am
dwain.c (11/6/2013)
You just need to use the SQL IFCode Shortcut (tag) that appears to the left of the posting window.
Thanks dwain! I did put it in the tags but still...
November 7, 2013 at 7:49 am
NJ-DBA (7/19/2013)
August 30, 2013 at 7:47 am
Hmmm.. back to the drawing board:
Got this: "Database Snapshot is not supported on Standard Edition (64-bit)."
Not sure my boss is going to fork out the extra 25K for upgrade to...
January 3, 2013 at 6:57 am
Thanks for lightning fast Anthony
Looks like that will do the trick. Just need to add some stuff to manage the disk space
Seems I need to do the following
Create snapshot of...
January 3, 2013 at 6:11 am
Sean Lange (10/10/2012)
What I don't understand is why there is a need to have an...
October 10, 2012 at 2:30 pm
Jeff Moden (9/28/2012)
October 2, 2012 at 5:43 pm
Viewing 15 posts - 1 through 15 (of 26 total)