Viewing 15 posts - 1,756 through 1,770 (of 14,953 total)
Joy Smith San (4/5/2012)
If you look at it in the regard that a heap is index type of 0, then you could make the argument...
- 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 5, 2012 at 6:30 am
GilaMonster (4/4/2012)
peter 82125 (4/4/2012)
Thanks for the reply. CDC changes the database by adding tables. That's not an option on this project.
Why not? What about change tracking? SQLAudit?
We had this...
- 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 5, 2012 at 6:23 am
Evil Kraig F (4/4/2012)
GSquared (4/4/2012)
Evil Kraig F (4/4/2012)
http://www.sqlservercentral.com/Forums/FindPost1278324.aspx
Is that supposed to mean something or am I just over-sensitive...
- 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 4, 2012 at 1:29 pm
Evil Kraig F (4/4/2012)
http://www.sqlservercentral.com/Forums/FindPost1278324.aspx
Is that supposed to mean something or am I just over-sensitive due to frustration 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 4, 2012 at 1:23 pm
MERGE tableA USING
(SELECT ITEM, DESCRIPTION FROM tableB) as src
on tableA.somecolumn = src.somecolumn
WHEN NOT MATCHED BY TARGET THEN
INSERT (ITEM, [DESCRIPTION])
SELECT ITEM, DESCRIPTION FROM tableB
First, the source either needs 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 4, 2012 at 1:01 pm
Physical fragmentation is about files spread all over the disk. Logical fragmentation is about indexes that are out of their natural sequence and possibly spread all over the data...
- 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 4, 2012 at 11:04 am
I see three different schedule IDs in there. Do you have three jobs running, potentially at the same time?
- 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 4, 2012 at 11:00 am
capn.hector (4/4/2012)
Lynn Pettis (4/4/2012)
GilaMonster (4/4/2012)
A new misspelling for my records...Thank you Linn and Gylla
Me too.
i always like the ones that thank my post count level thingy (ssc-whatever)
I get a lot...
- 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 4, 2012 at 8:49 am
amy26 (4/3/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 3, 2012 at 10:58 am
Roy Ernest (4/3/2012)
Long time since I have been here.... Did I miss anything other than Spanish Inquisition?
Welcome back!
- 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 3, 2012 at 10:56 am
capn.hector (4/3/2012)
GSquared (4/3/2012)
Brandie Tarvin (4/3/2012)
Revenant (4/2/2012)
AUI, meaning Administering Under Influence.Isn't that illegal?
I'm sure there's some sort of law against that... Or is the law for it? I can never remember.
I'm...
- 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 3, 2012 at 10:55 am
This sounds like a classic analysis cube situation.
Correct me if this is wrong: You need to know things like, if item X is purchased, how frequently does item Y also...
- 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 3, 2012 at 9:08 am
Steve Jones - SSC Editor (4/3/2012)
No one "lost" points. There isn't a total from which we remove them. You earn them, or you don't.
We all recognize the concept of "opportunity...
- 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 3, 2012 at 8:31 am
TravisDBA (4/3/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 3, 2012 at 8:29 am
Brandie Tarvin (4/3/2012)
Revenant (4/2/2012)
AUI, meaning Administering Under Influence.Isn't that illegal?
I'm sure there's some sort of law against that... Or is the law for it? I can never remember.
I'm pretty sure...
- 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 3, 2012 at 8:28 am
Viewing 15 posts - 1,756 through 1,770 (of 14,953 total)