Viewing 15 posts - 1,636 through 1,650 (of 14,953 total)
Just to be sure, I tested my version with your original example string, and with:
DECLARE @String VARCHAR(100) = 'ABCDEFG (9105) CDD NOT REPEATING & (1690) ENGINEERING' ;
Nothing in that string...
- 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
April 23, 2012 at 1:04 pm
If you don't know what string will appear twice, or if one will at all, try something like this:
DECLARE @String VARCHAR(100) = 'ABCDEFG (9105) CDD ABCDEFG (1690) ENGINEERING' ;
;
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
April 23, 2012 at 12:53 pm
On the point of knowing if a certain column is updated, you can use an Output Into clause to check before/after on a column pretty easily. That keeps it...
- 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
April 23, 2012 at 12:24 pm
GilaMonster (4/23/2012)
You can use SET CONTEXT_INFO and CONTEXT_INFO(), but it requires changing every single procedure
And will skip if someone does an ad hoc Update script, or if any...
- 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
April 23, 2012 at 12:19 pm
Steve Jones - SSC Editor (4/23/2012)
The Dixie Flatline (4/19/2012)
Well I was... except for the part about dying at PASS. 😉Glad you're OK, and back.
Editing that post down...
- 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
April 23, 2012 at 12:15 pm
I'd have to see the reason for the Union All statements (evident from the query, most likely) to be more specific, but if it's all coming from one table 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
April 23, 2012 at 12:12 pm
From what I can see, it's a problem with Quest Lightspeed trying to compress backups. Not limited to SQL 2005, and seems to have started about version 5.0.1 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
April 23, 2012 at 12:07 pm
Dump the presenttime column, and replace it with either one column for the number of minutes present (can be converted to hours and minutes either in queries or 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
April 23, 2012 at 11:58 am
Do you have backups you can restore from?
Have you checked for I/O issues to your data files?
Those two steps are where you should start.
- 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
April 23, 2012 at 11:48 am
Triggers don't have access to data in that scope. They just know what changed, not how.
- 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
April 23, 2012 at 11:07 am
I was going to comment about open source software being user-patchable, but I was beaten to the punch on that.
There are other drawbacks to OSS, but that is one 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
April 23, 2012 at 11:04 am
jay-h (4/23/2012)
terrance.steadman (4/23/2012)
- 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
April 23, 2012 at 11:00 am
Yeah, the documentation leaves a bit to be desired. Lots of circular definitions, last time I checked.
A "role" is a set of permissions. For example, "db_datareader" is a...
- 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
April 23, 2012 at 10:55 am
TravisDBA (4/23/2012)
To me, it's like having a conversation in a public park with friends. Someone might overhear me, but in general, most of what I say is limited 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
April 23, 2012 at 10:37 am
Yes, the good old, "going to work to rest up from life" type situation. Been there many times.
Hope the move went well and was for a positive reason.
Definitely good...
- 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
April 23, 2012 at 10:35 am
Viewing 15 posts - 1,636 through 1,650 (of 14,953 total)