Viewing 15 posts - 8,671 through 8,685 (of 14,953 total)
If the time difference is extreme, you can simply execute both procs in Management Studio and look at the execution time at the bottom of the screen.
I've had ones where...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 10:17 am
GilaMonster (8/19/2009)
Jack Corbett (8/19/2009)
GilaMonster (8/19/2009)
*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!Congrats, but of course exactly what I'd have expected for you, barring the one negative comment.;-)
Comment...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 10:15 am
There isn't a way I know of to do exactly that, but if you query the job schedule in msdb, you should be able to compare the times it was...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 8:22 am
Are you just talking about generating test data, or do you mean you want it random and unique in the production database?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 8:18 am
Mike in Michigan (8/19/2009)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 8:16 am
Lynn Pettis (8/19/2009)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 8:09 am
It's an older process. Essentially, a retronym. Warm backups are more technically complicated at the engine and OS level, and thus arrived on the scene later.
I've...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 8:07 am
GilaMonster (8/19/2009)
*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!
Well done!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 8:03 am
Dave Ballantyne (8/19/2009)
GSquared (8/19/2009)
Okay, I'll bite. Why is that one surprising?
Just simply because after 10 years+ of solid TSQL work, i'd never needed to do that.
You learn something new...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 7:49 am
Sounds like a pretty standard "contract-to-hire" situation to me. Lots of companies do that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 7:09 am
Source control for all scripts run against the database is also a good way to control and track what objects get created/modified/dropped.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 7:04 am
3) Some-one reported that they shrank the log file and they lost data. At first I didn't think that was possible but then I read:
http://articles.techrepublic.com.com/5100-10878_11-5173108.html
I just read that article, and...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 7:03 am
Dave Ballantyne (8/19/2009)
On a more positive note, a question that made me think, "CAN you do that" ?http://www.sqlservercentral.com/Forums/Topic773249-145-1.aspx
Okay, I'll bite. Why is that one surprising?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 19, 2009 at 6:52 am
Lynn Pettis (8/18/2009)
RBarryYoung (8/18/2009)
Lynn Pettis (8/18/2009)
RBarryYoung (8/18/2009)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 18, 2009 at 2:56 pm
If you really want a UDF, try this:
CREATE FUNCTION HierarchyTop (
@OrgUnitID_in VARCHAR(12))
RETURNS VARCHAR(12)
AS
BEGIN
DECLARE @Top VARCHAR(12) ;
;
WITH ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 18, 2009 at 2:54 pm
Viewing 15 posts - 8,671 through 8,685 (of 14,953 total)