Viewing 15 posts - 2,041 through 2,055 (of 14,953 total)
Lynn Pettis (2/7/2012)
Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...
- 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 8, 2012 at 8:28 am
dinesh8804 (2/6/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 8, 2012 at 8:19 am
cengland0 (2/6/2012)
GSquared (2/6/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 8, 2012 at 8:16 am
Probably not a deadlock or maxdop issue. If a shared connection suffers an error that closes the SPID (16 or higher, if I'm not mistaken), then anything else trying...
- 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 8, 2012 at 8:05 am
Artificial status hierarchies are just that, artificial.
A Senior DBA will often be better paid than his manager is, so "promotion" becomes simply a change in role.
The list you gave for...
- 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 6, 2012 at 11:38 am
Beyond what Grant says, MS recommends setting maxdop to 8 on servers with more than 8 CPUs, because the cost of spreading the job out will be more than 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 6, 2012 at 11:35 am
Jeff Moden (2/6/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 6, 2012 at 8:14 am
GilaMonster (2/6/2012)
1 - http://www.sqlservercentral.com/Forums/Topic1247308-391-1.aspx An article on SVVM in reply to a question on SQL versions.
2 - http://www.sqlservercentral.com/Forums/Topic1247195-392-1.aspx A while loop to delete all the rows in a table is...
- 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 6, 2012 at 8:13 am
It is possible to join without using Join.
You can Union the tables and then Pivot them. It's a bad idea, takes a lot of work, and you 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
February 6, 2012 at 6:54 am
cengland0 (2/6/2012)
jcb (2/6/2012)
Some app use, at least, parameterized dynamic sql and it blocks most problems...
- 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 6, 2012 at 6:44 am
Steve Jones - SSC Editor (2/3/2012)
snow, snow, snow.
Now you're just trying to make me jealous! 🙂
75F here in Orlando. Just about perfect out for a picnic or something comparable....
- 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 12:37 pm
ashutosh.kumarpandey (2/3/2012)
have you tried cross join...simplyselect * from tableA,tableB
That (a) won't give the results he outlined, and (b) uses a Join, even if it avoids using that word.
- 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 9:23 am
GilaMonster (2/3/2012)
Thanks, more than enough editors now.
What editors? We just want a sneak preview, and we're willing to point out a missing comma or two in order to get...
- 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:50 am
GilaMonster (2/2/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 3, 2012 at 6:48 am
Nadrek (2/1/2012)
mtillman-921105 (1/30/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 3, 2012 at 6:40 am
Viewing 15 posts - 2,041 through 2,055 (of 14,953 total)