Viewing 15 posts - 91 through 105 (of 107 total)
After intitially having a bit of grief with it (NT vs Win2K servers, WMS or no WMS, etc.) I have had it up and working well for a couple of...
June 30, 2004 at 10:38 am
Yes, it IS supposed to be reasonably fun. If it's not, you've got the WRONG JOB.
June 29, 2004 at 10:10 pm
I used to be big on MS products but now am learning PHP. As a SQL Server DBA, I will inevitably have to learn C# due to the CLR in...
June 29, 2004 at 12:55 pm
Here's something I got from the Microsoft site -- Works pretty well(Sorry all the indenting goes out of it with this post. Get the original off the MS site if...
June 22, 2004 at 11:16 pm
1. Never put spaces or dashes in any object names (columns, table names, server names, etc). It will only turn around and bite you later. Understores are OK.
2. Learn a...
November 20, 2003 at 12:58 pm
If you use certain types of software, like Great Plains for example, you must use the sa password to set it up, and in the case of GP, to administer...
November 13, 2003 at 11:40 am
Guru's Guide to Transact SQL by Henderson. It has many practical examples.
October 29, 2003 at 6:20 am
Python and PostgreSQL would be my choice.
October 3, 2003 at 10:27 am
Also and FYI:
There's a great script called sp_help_revlogin (by Gregory A. Larsen) which copies all your server logins to another script you can use to recreate them on another server....
September 30, 2003 at 9:06 am
I use PKZip for Windows. It's cheap and well worth the money. It's also faster and more efficient on Memory usage than anything else out there. I have no problem...
August 13, 2003 at 8:50 am
Yes. DBCC CHECKIDENT with RESEED PARAMETER.
As in:
DBCC CHECKIDENT ('MyTable',RESEED, 1)
July 22, 2003 at 10:34 am
If your developers will have the ablity to create (or ask for the creation of) tables, columns, views, procs, etc., tell them NOT to include any spaces or dashes (-)...
June 16, 2003 at 12:28 am
I believe this script came from the db journal website. First run the script for about 10-15 seconds and MANUALLY STOP IT. Then run the first of the 2 comments...
January 16, 2003 at 2:13 am
I believe this script came from the db journal website. First run the script for about 10-15 seconds and MANUALLY STOP IT. Then run the first of the 2 comments...
January 16, 2003 at 2:13 am
You could also approach if from the other end. Use MS Query in Excel and past your SQL into the MS Query SQL window. You can put a button on...
January 16, 2003 at 2:04 am
Viewing 15 posts - 91 through 105 (of 107 total)