Viewing 15 posts - 10,936 through 10,950 (of 14,953 total)
BOL was very nearly useless to me when I started out. Here's an example of why even a simple question can get frustrating.
I had an Access database that I...
- 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 17, 2009 at 3:04 pm
RBarryYoung (2/17/2009)
My nominee for the week: http://www.sqlservercentral.com/Forums/Topic658615-1281-1.aspx?Update=1*sigh*
Brillant!
- 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 17, 2009 at 1:43 pm
You would either do that with Where Not Exists or with Where Not In, and then a query of the SSCC values that have incomplete boxCompleted values. Would look...
- 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 17, 2009 at 1:41 pm
Per Microsoft, on http://msdn.microsoft.com/en-us/library/ms143393.aspx, you can only upgrade to 2008 Enterprise from that version.
Doesn't mean you can't get a copy of Standard and upgrade your databases and such into 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
February 17, 2009 at 1:31 pm
I don't suppose it would be possible to have the data you keep be in one database or in one file in a database, and the rest be in another...
- 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 17, 2009 at 1:26 pm
Luke L (2/17/2009)
- 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 17, 2009 at 1:20 pm
Max (2/17/2009)
Man, you guys are so lucky, we were so poor I had to push the horse up the hill. 😉
Sisyphus move over! New guy with version 2.0 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 17, 2009 at 1:18 pm
I would definitely get rid of the shrink tasks. Automated database/log shrinking is almost always a bad idea.
I think the backups should be fine. Don't bother with scripts...
- 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 17, 2009 at 1:13 pm
Something that was really helpful to me when I was first learning how to build databases and code them was Microsoft's wizards for various things. I'd open the table...
- 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 17, 2009 at 1:09 pm
What you need to do is use a "string parser" to break the IDs into a table instead of a row of comma-separated values.
There are several of those in 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 17, 2009 at 12:59 pm
Bert (2/17/2009)
GSquared (2/2/2009)
tosscrosby (2/2/2009)
Jeff Moden (2/1/2009)
Of course, I used to think punched cards and wired program boards were a lot of fun, too! 😛
You should see the faces of 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 17, 2009 at 12:51 pm
Bruce W Cassidy (2/16/2009)
[font="Verdana"]I have yet to see a business judge an RDBMS on "which is easier to program in?"[/font]
I've seen three that made that exact decision. As 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
February 17, 2009 at 12:40 pm
On the point of the article, about having a "code checker" for SQL, I don't think it would really be possible, at this point, to automate such a system. ...
- 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 17, 2009 at 12:32 pm
Can't you just change it in the Layout tab? I could be wrong, but I think you should be able 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 13, 2009 at 9:39 am
Grant Fritchey (2/13/2009)
GSquared (2/13/2009)
(I can legitimately and truthfully claim that I dropped out of both kindergarden and college. Not many...
- 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 13, 2009 at 9:37 am
Viewing 15 posts - 10,936 through 10,950 (of 14,953 total)