Viewing 15 posts - 37,996 through 38,010 (of 39,720 total)
Looks about right, but the system tables could change in an upgrade. Information_schema views are standard views that will stay the same.
Steve Jones
March 18, 2002 at 4:10 pm
Tend to agree. You should know how much your dbs need for a log and give a little buffer. Also, limit growth. Unlimited growth is just begging for the disk...
March 18, 2002 at 4:07 pm
congrats!!!
BTW, I use a one-time random password for each account. Separate SQL user for each server. Once the service is setup, I toss the pwd. If I need to...
March 18, 2002 at 2:18 pm
March 18, 2002 at 2:14 pm
March 18, 2002 at 2:10 pm
March 18, 2002 at 12:14 pm
Definitely cheaper, but there are some differences. The course includes reminders and interaction with instructors as well as exams and tests. I'm sure the book has tests, but having it...
March 18, 2002 at 12:13 pm
I agree with Brian. Doesn't have to be admin, but much easier. HOWEVER, make it a local admin, not a domain admin. Note that this does mean that you do...
March 18, 2002 at 12:11 pm
To me, dates are the only real issue. I wish they had included something in cast, even an exension, to handle dates, but I guess that's more of a standards...
March 18, 2002 at 12:09 pm
I have a series on how I do it. I could do more automation, but since the release cycle is so quick (1-2 weeks for me), automation may not be...
March 18, 2002 at 8:46 am
Encrypting the data files will not really help. You need SQL Server to read them anyway, so I'm not sure this is worth the CPU cycles to do it. Better...
March 18, 2002 at 8:42 am
If any of you dig further on this, I'd be interested to know what you find. I suspect there is some process in SQL Server that checks the time on...
March 18, 2002 at 8:40 am
No other great suggestions right now. At $699, I'm not sure. It's cheaper than the classroom and you'd probably learn as much, but you lose the ability to interact with...
March 15, 2002 at 1:41 pm
Used it as a test, but it didn't seem to add much for me. Also, it's not too often that I have the same jobs on a server, so distributing...
March 15, 2002 at 1:40 pm
That's a nice suggestion. We use a freeware forum codebase, and I'm not sure this is supported, but it is something worth undertaking. Personally I use the "Active Threads" ...
March 15, 2002 at 1:36 pm
Viewing 15 posts - 37,996 through 38,010 (of 39,720 total)