Viewing 15 posts - 4,096 through 4,110 (of 14,953 total)
opc.three (6/7/2011)
I went looking after your last post and came up empty. Care to share a link?
The element directive generates a contained element instead of an attribute. The contained 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
June 7, 2011 at 6:53 am
If by "no longer in use" you mean the databases have been dropped, you could join that query to sys.databases, and that would filter it for you.
- 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
June 7, 2011 at 6:50 am
Lowell (6/7/2011)
you said "... If a plan is never cached, it won't appear in the query stats DMV at all...", can you clarify?
I thought every...
- 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
June 7, 2011 at 6:43 am
If @@version is showing Workgroup, it will actually be up to the hosting company to prove otherwise.
Most likely, it's not an intentional deception. Someone installed Workgroup where...
- 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
June 7, 2011 at 6:36 am
mtillman-921105 (6/6/2011)
And you may be assuming too much if you think math and philosophy are separate subjects. Math is a language for expressing a subset of philosophy.
Actually GSquared, Frege tried...
- 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
June 7, 2011 at 6:29 am
mtillman-921105 (6/6/2011)
Actually, that's kind of what negative numbers are for. 1 + -1 = 0.
Exactly GSquared. But isn't that kind of an ad hoc sort of explanation? ...
- 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
June 7, 2011 at 6:20 am
opc.three (6/6/2011)
XSINIL is a good tip. It is an option if you switch your query from EXPLICIT to ELEMENTS.
Explicit can do the null columns thing, you just have to code...
- 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
June 7, 2011 at 6:17 am
Good to know it can be a problem in R2, and that there's an easy way to resolve 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
June 7, 2011 at 6:16 am
Zeal-DBA (6/6/2011)
following Ques.. i remember.
Q1 explain ACID
Q2 explain how a T-log follows ACID properties with example
Q3 difference between 32 bit and 64...
- 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
June 7, 2011 at 6:13 am
calvo (6/6/2011)
Perhaps a bad example 🙂
Along GSquare's line of thinking, just the fact that you are...
- 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
June 6, 2011 at 12:56 pm
mtillman-921105 (6/6/2011)
calvo (6/6/2011)
mtillman-921105 (6/6/2011)
“As far as the laws of mathematics refer to reality, they are not certain; and as far as they are certain, they do not refer to reality.”
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
June 6, 2011 at 12:46 pm
mtillman-921105 (6/6/2011)
GSquared (6/6/2011)
(I think you may have quoted the wrong post, but I think I know where you wanted to come from on this.)
The problem with that statement about true/false...
- 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
June 6, 2011 at 12:42 pm
Does your query also have an Order By clause? If not, Top can/will do strange things.
- 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
June 6, 2011 at 11:42 am
calvo (6/6/2011)
Come on Mr. Credentials! Help us understand!(Mr. Credentials = GSquared. The previous statement is true)
Or at least true enough. 🙂
- 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
June 6, 2011 at 11:40 am
calvo (6/6/2011)
GSquared (6/6/2011)..."Billion" means two different things on different sides of The Pond.
wow. I was about to question this when I looked it up, totally threw me for a loop.
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
June 6, 2011 at 11:39 am
Viewing 15 posts - 4,096 through 4,110 (of 14,953 total)