Hi,

If you want to know how big sys.syscomments is, you need to calculate row size and multiply by # of rows. It shouldn't be much, so I wouldn't worry to...

Hey,

Have you checked permissions on file system to ensure you can create the file?

Try creating a sub-directory and then running utility (e.g. c:\test\sample.txt)

Thanks,

Phillip Cox

hey,

This is kind of an open-ended question, as performance can be improved in a number of areas, but you first need to identify your performance bottlenecks. Can you provide...

Currently working with Veritas Cluster supporting SQL Server 2005 and it provides a fairly robust clustering solution.

Thanks,

Phillip Cox

Hi,

Unless you are running other applications or using named SQL Server instances on the same server, you should be fine with the default memory configuration, which will work dynamically with...

Hi,

You can put the subscription database(s) into simple mode without issue.

Thanks,

Phillip Cox

hey,

what are you trying to understand, as question not clear?

Thanks,

Phillip Cox

Hi,

This should help:

http://support.microsoft.com/kb/218590

Thanks,

Phillip Cox

Hi,

Similar to what Matt has requested, where does the application sit infrastructure wise?

What type of application are you running (e.g. web or client-server)?

How long ago was application implemented and did...

We use LiteSpeed, which is currently backing-up 1TB+ databases, so highly recommended!

Hope this helps,

Phillip

Hey,

To mitigate a slow log reader, you may want improve I/O of the underlying disk, by adding more disks, updating raid level to either Raid 1 or Raid 10. ...

Hi,

You may want to post in General area next time for this type of question, as its not directly related to replication. Here is a starting point for you:

Hey,

In terms of running your SQL Server system on direct-attached storage vs SAN storage is primarily concerned with following:

1. Capacity

2. Performance

3. Scalability

4. Availability

5. Reliability

6. Cost

DAS -...

Hey,

You have two cache types, which are data and procedure. SQL Server automatically manages the cache clean-up or refresh by probing each buffer via the lazy writer process or...

Hey,

Here's syntax example, but you may want to have a look a BOL for more information:

sp_configure [ [ @configname = ] 'option_name'

[ , [ @configvalue...