Viewing 13 posts - 256 through 268 (of 268 total)
Be Professional
Check out http://www.tomshardware.com/. These guys test computer hardware and have a knack for being "Brutally honest" without being overly harsh. They perform detailed tests under fair conditions and stick...
March 24, 2003 at 1:40 pm
This option should not be available for servers but it is quite useful for desktop applications using MSDE; in fact, MSDE databases have this set as the default. There is...
March 11, 2003 at 10:14 am
In the article you stated "you'll have to store your code in a file and execute it as an OS task using wscript.exe" but what you really want to use...
March 11, 2003 at 10:02 am
What Microsoft released prior to the Slammer crisis was little more than a "Here's a patch so you can't blame us" release. I manage over 140 SQL Servers (Not including...
February 6, 2003 at 8:26 am
Some additional comments and corrections (from experience):
the 039 patch is not sufficient to keep a server from becoming infected and, from what I have seen, SP3 does not keep SQLSlammer...
January 27, 2003 at 10:27 am
I tried this on my installation of SQL Server 2000 (SP2 plus security patch 061) and it couldn't find the table. It turned out that the table name in the...
January 27, 2003 at 10:08 am
SQL Server 2000 SP3 is supposed to have an option to enable cross-database ownership chains. This might help you out (in 1-2 weeks).
Bryant E. Byrd, MCDBA
SQL Server DBA/Systems Engineer
Intellithought, Inc.
January 13, 2003 at 1:33 pm
I find it a lot easier to remember where something is in a book on my shelf than trying to search a web site to find the article I read...
January 6, 2003 at 11:19 am
Another reason to name your constraints is to help debug applications. A foreign key violation message states which column(s) in the key table were violated but doesn't tell you the...
August 27, 2002 at 2:04 pm
SQL logins are the only way to handle connections for web applications that connect directly from ASP code to the database with no intermediate components; otherwise, SQL logins have no...
July 9, 2002 at 9:28 am
Without a doubt, as a DBA or a developer, storing the images in the same DB as the rest of the data is the best way to handle it.
Developer point-of-view:...
May 13, 2002 at 3:26 pm
As a developer or DBA, the most important think you can know is "where to look". You don't know everything. You can't know everything so don't try; that is what...
April 16, 2002 at 3:19 pm
Another advantage of the BAS file is that you can perform search and replace functions on it from your favorite text editor. This has come in handy for me when...
March 21, 2002 at 3:00 pm
Viewing 13 posts - 256 through 268 (of 268 total)