Here's a T-SQL example using tempdb:

 alter database tempdb modify file

  (name = templog,

  size = 512MB,

  maxsize = 1025MB,

  filegrowth = 256MB)

 go

 checkpoint

 go

1.Yes. But I would perform an upgrade to v7.0, then upgrade to 2000.

2. Yes.

3. It's been quite a while since I used v6.0, but I do not believe you can.

A few points about striping. For small databases the time savings might not really appear. By small I mean <2-4 Gb databases. You'll have to do some experimentation to find...

A 4G database backup is really quite small. A restore of a database this small should only take 2-4 minutes (unless the disks or server are exceptionally slow). As an...

I just signed up for the 'beta' ... we'll see what is can do ... I've quite a few challenges for it ... MSSQL, Oracle, UDB2, Linux, ksh, just to...

Besides the /3GB in the boot.ini file you'll need to run:

exec sp_configure 'min server memory (MB)',3072

exec sp_configure 'max server memory (MB)',3072

exec sp_configure 'set working set size',1

reconfigure with override

The SP as written will not even compile. It produces the following errors:

Server: Msg 137, Level 15, State 1, Procedure spTester, Line 6

Must declare the variable '@result'.

Server: Msg 137,...

Thank you. I learned something new today, that 'truncate' is a DDL statement ! I thought it might be DML

I stand corrected (there's always more than one way to do something in SQL). The one fly in ther ointment is that the user executing the command must be a...

It is not possible. You can select, insert, update and delete (with proper linkage and permissions of course) but if you attempt a truncate statement you will receive the following...

I feel that 'disappointing' is not descriptive enough a term.  'extremely late' does seem to fit better seeing as this type of announcement is a tad late by about 5...

It sounds as if you were 'playing' with regedit (which can be quite dangerous). In order to fix things you will need to perform a Windows search to find the...

Could you post your .odbc.ini file from the Unix server ? Also, have you checked with your network folks about firewalls and routing tables ? It's possible that 1433 is...

Out of curiosity why would you want to know ? I ask that because SQL Server writes 'dirty' pages out to disk quite frequently. The 'lazy writer' performs this task...

I am 99.44% sure that 'load balancing' of a query across servers in a cluster is not possible. The query optimizer will decide if 'parallelism' (splitting up the query and...