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...
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!
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...
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,...
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...
February 17, 2009 at 1:26 pm
Luke L (2/17/2009)
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...
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...
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...
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...
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...
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...
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. ...
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.
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...
February 13, 2009 at 9:37 am
Viewing 15 posts - 10,936 through 10,950 (of 14,953 total)