Viewing 15 posts - 6,631 through 6,645 (of 14,953 total)
AVB (4/14/2010)
GSquared,You said that it took your servers off-line most of the day. Was that both servers ("failed to" and "fail back")?
Yes, both sites go offline (effectively) while failing back.
Steve...
- 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 14, 2010 at 3:14 pm
CirquedeSQLeil (4/14/2010)
WayneS (4/14/2010)
CirquedeSQLeil (4/14/2010)
WayneS (4/14/2010)
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.It looks like you can come back now.
And I did. ...
- 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 14, 2010 at 3:13 pm
CirquedeSQLeil (4/14/2010)
Anybody want to dream and slobber?
Nice! But I'll wait for the price to come down more than a little bit.
- 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 14, 2010 at 11:38 am
Steve Lavoie:
I understand that you have a vested interest in proving that XOSoft cannot create the situations that I have described. Nevertheless, the physical universe disagrees with your theories,...
- 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 14, 2010 at 11:32 am
Alvin Ramard (4/14/2010)
GSquared (4/14/2010)
Alvin Ramard (4/14/2010)
CirquedeSQLeil (4/13/2010)
Oddity in the forums. I just noticed that I lost 27 points today. Am curious where they could have gone.
Those 27 points...
- 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 14, 2010 at 10:02 am
Alvin Ramard (4/14/2010)
CirquedeSQLeil (4/13/2010)
Oddity in the forums. I just noticed that I lost 27 points today. Am curious where they could have gone.
Those 27 points were from bad...
- 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 14, 2010 at 8:19 am
Jeff: I understand that IsNumeric does what it's designed to do, but I still consider it "flawed" because it has almost no practical use in my experience. That's why...
- 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 14, 2010 at 6:30 am
aishuapte (4/13/2010)
It runs from visual studio but when deply report and run it from report server...
- 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 14, 2010 at 6:21 am
Bill Kline-270970 (4/12/2010)
Virtualization almost eliminates the need for it and the advantages of it. Improving virtualization will make "scale out" on SQL Server a moot point faster than...
- 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 14, 2010 at 6:20 am
You can't use dynamic SQL in a function (assuming you mean an SQL User-Defined Function).
- 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 14, 2010 at 6:17 am
kevin77 (4/13/2010)
- 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 14, 2010 at 6:12 am
I'm not sure a report can do that. Most it can be done with drill-down reports, but I'm not sure about the highliting part.
- 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 14, 2010 at 6:03 am
I SERIOUSLY wish I'd had access to this site when I first started out. Unfortunately, it didn't exist yet.
I learned more in my first year here than I did...
- 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 12, 2010 at 3:16 pm
Empty strings = 0. It's kind of arbitrary, but that's how it works.
IsNumeric has a number of flaws, this is just one of them. Check out IsNumeric('1d3') 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
April 12, 2010 at 2:20 pm
bteraberry (4/12/2010)
If you have an aversion for case statements you could also do
select isnull(CAST(ceiling(coalesce(Col1,Col2,Col3,Col4,Col5,Col6)) as bit), 0)😛
I'm pretty sure, if one of the values is 0, that will return 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 12, 2010 at 2:10 pm
Viewing 15 posts - 6,631 through 6,645 (of 14,953 total)