That's what I thought should happen. Although, I'm a little confused because we have another server that has much less usage and SQL Server is using close to 3.0GB of...

Min setting is 0.

I changed jobs in Oct '07 and the market for SQL Server DBAs was great in the Chicago area. The recruiters/employers were relentless and they said there were more jobs...

I have worked for several companies and never provided salary history on my resumes. However, I reluctantly give a salary range when asked, so as to not give the impression...

I have subscribed to the magazine for several years and think it's very worthwhile. I purchased the CD once early on but never really used it. I always end up...

I couldn't agree with you more...wish I was going! 🙂

As much as some of us hate to admit it, we all are part of the political capital game. It plays a role in all aspects of life. My spouse...

If I am in an interview and asked to respond to a question that I know is false, my immediate response would be "Is this a trick question?". Then I...

As a workaround, I used a slightly different method that allows one to manipulate the SQL

before it is writtent to file. REPLACE is used to eliminate all brackets before output...

Another method is to use a lookup table. This is helpful especially if you have a multi-customer environment where you have to be selective in the databases to be included...

What kind of RAID array does your server have? Have you verified all disks in array are good?

Try stopping/re-starting SQL Server.

Whenever I get this error, I break it down by selecting from primary table, then adding joins one-by-one until the error. Check the following as you do this:

- derived tables...

You can filter on ObjectID (Filters tab of Trace Properties form) for the UDF. Obtain ID from sysobjects system table.

If your main challenge is dynamically obtaining the structure for any table, doing something like the following may help:

declare @sql varchar(1000), @TblNm varchar(100)

set @TblNm = 'Table'

set