Viewing 15 posts - 1,906 through 1,920 (of 14,953 total)
L' Eomot Inversé (3/1/2012)
GSquared (3/1/2012)
There are legit points on both sides of that argument.
I think there are actually three different things here, and I don't think there's two sides 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
March 2, 2012 at 8:14 am
Nadrek (3/1/2012)
GSquared (2/29/2012)
isuckatsql (2/28/2012)
Thanks for the feedback!Is running the o/s on SSD worth the money?
Woudn't bother using SSD for the O/S on a server, unless you haven't got any other...
- 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
March 2, 2012 at 7:33 am
To the question about the nested From statements:
Those are what are called "derived tables".
You can do those in the body of the "outer query":
select *
from
...
- 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
March 1, 2012 at 10:18 am
SQLKnowItAll (3/1/2012)
The semi-colon at the start of his query is actually bad when demonstrating the method used for creating a CTE. It's there to terminate the previous statement but 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
March 1, 2012 at 10:11 am
Cool biz.
Glad I could help.
- 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
March 1, 2012 at 9:59 am
I took a bit closer look at Explicit, and you can specify elementxsinil in the directive part of a column name.
Example at: http://msdn.microsoft.com/en-us/library/bb522622.aspx
Documentation at: http://msdn.microsoft.com/en-us/library/ms189068.aspx
- 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
March 1, 2012 at 9:40 am
I don't think Explicit mode supports XSINIL in the FOR clause, so what you probably have to do is wrap the appropriate column in IsNull/Coalesce.
- 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
March 1, 2012 at 9:23 am
Stefan Krzywicki (3/1/2012)
Revenant (2/29/2012)
L' Eomot Inversé (2/29/2012)
I know I say this every time... but...
The alleged shortage is of what it has always been - 21 year olds with 5 years...
- 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
March 1, 2012 at 9:18 am
isuckatsql (2/28/2012)
Thanks for the feedback!Is running the o/s on SSD worth the money?
Woudn't bother using SSD for the O/S on a server, unless you haven't got any other plan 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
February 29, 2012 at 12:21 pm
If you're talking about Management Studio and Dev Studio (SSMS and BIDS), you shouldn't have any problem installing those on Win 7 64-bit. I've done that.
If you want 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 28, 2012 at 2:36 pm
Brandie Tarvin (2/28/2012)
Gianluca Sartori (2/28/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 28, 2012 at 11:40 am
satishm94 (2/28/2012)
can u guys tell me the answers to these question …PLZ
1)What is the purpose of Msdb database? If you delete msdb database insatance is running or not?
2)Login cannot...
- 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 28, 2012 at 8:29 am
Makes sense. You're welcome.
- 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 28, 2012 at 7:23 am
There are a couple of ways to do this.
Here are some samples. Try these, see if they get you started in the right direction.
DECLARE @XML XML = '<root><Books><Book><ID>2</ID><Name>Sql 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
February 28, 2012 at 7:20 am
Explicit vs Implicit.
Same reason it has "top 100 percent" in the same query. No point to that, since Select without a Top clause automatically does that. It's just...
- 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 27, 2012 at 2:27 pm
Viewing 15 posts - 1,906 through 1,920 (of 14,953 total)