You want to avoid growth in % for other reasons as well. When the db is small, say 50 MB, a 10% growth is minor. AS our newbie has discovered...

arun.samuel (3/6/2008)

---

I am having startup problem trying to form this query. Any help would be

appreciated.

I have a 3 tables :

1. tblCaseInfo with CaseID, ResolutionID

2. tblSessions with CaseID, Location

3....

Adam, when I encountered this problem it was not oprhaned users. We had been on SQL 2005 for 6 months when the problem arose. I wound up contacting MIcrosoft PSS...

Just curious, what is the "Max Size" set to?

You can run a profiler trace for a given period of time. The trace will include reads and writes and this data can be exported to a database. Be careful...

I ran into this issue too after upgrading to 2005 and then applying Windows SP2. It turns out that doing so enabled the "Enforce Password Policy" and other checkboxes. Check...

Yes, Coriolan, you can use the SET ROWCOUNT n to limit the rows returned. However, what you really need is some sort of paging similar to MySQL's limit function and...

1) Never perform maintenance (such as shrinking log files) during production hours.

That said, if you were shrinking the log file when SQL Server restarted you are most likely encountering a...

Jeff, I didn't mean to step on your toes and indicate that either of these scripts were different. I was speaking in general terms to let our Newbie know that...

You are...

Without using a CTE this can be accomplished with the following...

select uniqueID from t1 join

( select SN, max(RevisionNUmber) rn from group by SN ) v on

v.SN...

You can do this without a case statement. Try this...

Where

isnull( a.director, 1) = 1 or a.director = b.director

Chris, look at replication in Books Online

Dab

Yuri, why is the page file only set at 4 GB?

It seems as though the OS is starved for memory at times (causing the 100% spikes). SQL may only be...

Sram, your best bet is to use some sort of load process (SSIS, openquery(), MySQLdump, etc. ). In conjuntion with the MySQL 3.51 conncetor http://dev.mysql.com/downloads/connector/odbc/3.51.html[/] you can use openquery() to...