Viewing 15 posts - 2,056 through 2,070 (of 14,953 total)
DavidL (2/1/2012)
I'm assuming this isn't just a matter of rows being in a different order than expected. There are less/more rows different times, right?
Correct. The example I sent...
- 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
February 3, 2012 at 6:36 am
dinesh8804 (2/2/2012)
create table t2(comments varchar(10))
insert into t1 values(100)
insert into t1 values(200)
insert into t2 values('d')
insert into t2 values('i')
I have created two tables t1 and t2.i have different two...
- 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
February 3, 2012 at 6:31 am
If I'm not mistaken, both SQL Server Audit and Change Data Capture are Enterpise edition features. Or has that changed?
Standard edition and below, Output and/or triggers, possibly combined 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
February 2, 2012 at 12:34 pm
Here's a sample with correct semicolons:
IF 1 = 1
BEGIN ;
PRINT 'Yep' ;
END ;
ELSE...
- 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
February 2, 2012 at 12:17 pm
What difference? I don't see any differences in sp_trace_create, sp_trace_setevent, or any of the related functions. Maybe some more events/columns added that I'm just not seeing?
Anyway, I have...
- 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
February 1, 2012 at 10:59 am
Not enough for me to see a real pattern to it.
I think I'd need access to the actual server and database to really determine what's going on. I'd test...
- 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
February 1, 2012 at 10:56 am
Jack Corbett (2/1/2012)
Evil Kraig F (1/31/2012)
A robot DBA may not injure data or, through inaction, allow data to come to harm.
A robot DBA must obey 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
February 1, 2012 at 10:52 am
Steve Jones - SSC Editor (2/1/2012)
GSquared (2/1/2012)
HowardW (2/1/2012)
Not sure whether to call it spam or not, but most of his posts...
- 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
February 1, 2012 at 10:48 am
L' Eomot Inversé (2/1/2012)
GSquared (2/1/2012)
HowardW (2/1/2012)
Not sure whether to call it spam or not, but most of his posts wouldn't pass...
- 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
February 1, 2012 at 10:48 am
HowardW (2/1/2012)
Is this guy annoying the hell out of anyone else?Not sure whether to call it spam or not, but most of his posts wouldn't pass the Turing Test.
Looks like...
- 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
February 1, 2012 at 8:38 am
dinesh8804 (2/1/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
February 1, 2012 at 7:45 am
arun1_m1 (2/1/2012)
Use a UNION ALL --> in case you want all records from both the tables.Use a UNION --> in case you want to eliminate duplicate records.
That won't work, since...
- 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
February 1, 2012 at 7:42 am
Evil Kraig F (1/31/2012)
Jeff Moden (1/31/2012)
Brandie Tarvin (1/31/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
February 1, 2012 at 7:18 am
Brandie Tarvin (1/31/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
February 1, 2012 at 7:15 am
I put the UDF through some simple unit-testing and it does appear to be deterministic, so I don't think that's the issue. (Had to confirm that, of course.)
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
February 1, 2012 at 7:09 am
Viewing 15 posts - 2,056 through 2,070 (of 14,953 total)