Viewing 15 posts - 8,641 through 8,655 (of 14,953 total)
GilaMonster (8/19/2009)
GSquared (8/19/2009)
Or video it, and review the video yourself. It's amazing what you'll note when you watch yourself in action. Sounds narcisistic, but it's really useful.
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 20, 2009 at 7:02 am
All the job data is in the msdb database. I haven't used SQL 2000 in a couple of years, so I'm a little rusty on where to look, but...
- 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 20, 2009 at 6:57 am
You're welcome.
- 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 20, 2009 at 6:49 am
The screen shot looks correct.
If that's not doing what you need, then there's something about the file that isn't matching up. Perhaps the code page?
- 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 3:01 pm
Yes. Depending on the complexities, we can come up with all kinds of ways of removing various patterns of strings from other strings.
I still think my first suggestion of...
- 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 3:00 pm
It sure helps.
A lot of what you'll do in administration can be done more efficiently with T-SQL scripts than it can through Management Studio's GUI. Some things need to...
- 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 2:34 pm
The query I wrote will give you the hour without the minutes on the ones you want that way.
It also handles last year the way you asked.
You don't need to...
- 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 2:29 pm
SSIS could definitely be used to smooth out the import process and make it more self-correcting.
On integrating the dev and production servers, the easiest way to do that is to...
- 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 2:19 pm
GilaMonster (8/19/2009)
Grant Fritchey (8/19/2009)
Did you get any constructive criticism? That's the stuff I live for, when someone actually has useful insights, not just "You did great" or "You stink."
Nothing really...
- 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 2:14 pm
You get a DBA and a Domain Admin to look at what he was logging in to and what rights he has, and they will fix it for you or...
- 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 2:10 pm
This will get you the data:
declare
@BeginDate datetime,
@LastBeginDate datetime,
@ConcludeDate datetime,
@LastConcludeDate datetime;
select
@BeginDate = dateadd(day, datediff(day, 0, getdate()), 0),
@ConcludeDate = dateadd(hour, datepart(hour, getdate()), dateadd(day, datediff(day, 0, getdate()), 0)),
@LastBeginDate...
- 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 2:09 pm
It depends on what you're looking for. Most of the white papers I use on those are on the MSDN site.
- 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 2:03 pm
Yes, that can be done in SSIS. It doesn't need a script task.
You would use a Data Transformation task to output all of the text files. You'd need...
- 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 2:02 pm
You do that with Update...From in T-SQL.
Would look like this:
update cust -- use the alias for the target table
set OID = OID_ACTUAL, FCID = FCID_ACTUAL
from myschema.customers cust -- alias the...
- 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 1:56 pm
There are tools that can do that for you, like Data Compare (RedGate) or SQLDiff (ApexSQL).
Otherwise, you're going to have to write a query that compares the data in the...
- 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 1:52 pm
Viewing 15 posts - 8,641 through 8,655 (of 14,953 total)