Does somebody has a query to rebuild or reorganized (depending on the level of fragmentation) all the indexes in the database? The only input parameter is a database name.. It...

Joe is correct...

Additionally, if the table is HEAP (no cluster index) then ur fragmentation not remove.

The above statements is true put the cluster index and drop it then ur fragmentation...

Hi Muthu,

Many thanks for your help.

I did what you advise me, and its work. however the "Target Server Memory" and "Total Server Memory" never going up more then 3.6GB even...

1) Checked this query " SELECT * FROM SYS.SYSALTFILES WHERE DBID=DB_ID('Db_name') " It is showing 1 GB Growth, maxsize unlimited

2) After running XP_FIXEDDRIVES it is showing Free Space on Drive...

Dear all,

I have some issue and I’ll be happy to hear some ideas.

1. I have 12GB RAM in my windows 2003 SBS server (Dell power edge 2900)

2. My SQL server...

I am getting following error frequently... Has anyone faced similar issue and resolved it....

Could not allocate space for object 'dbo.EventLog'.'PK__EventLog__71957DB0' in database 'eventlog' because the 'PRIMARY' filegroup is full. Create...

Hi,

Y i get extra benefit. (May I know the reason)

Thanks,

Muthu,

Hi,

The table has only 5700 rows.so...

EdVassie,

Thanks for ur Replay,Yes the server now running fast but,

I am not give the the sql...

Hi EdVassie,

Thanks for ur Replay It's Great.

Again one Question

I couldn't give the the...

Hi,

Thanks for ur replays.I have 2-Question.

Case:1

I have 16 GB RAM and 2-node A/P Cluster.(AWE...

MANU,

Thanks for ur reply This is Production Database the developer are using daily and We have low disk Space.

Is there any...

Nicholas Cain (2/9/2009)

---

It very much depends on how your data grows. It could be anywhere from 10MB to 1GB. First thing you should do is proactively manage your file growth....

Hi,

Thanks for ur Replay. Right now I change the backup path Sakthi.

(Don't shrink the log file is my first recommendation)

Nicholas I accept ur recommendation

Instead of...

Hi,

Thanks Again My Recovery model is full and,Today I manually shrunk my log file but the IO ERROR is coming daily night time before running checkdb.

2009-02-02 02:22:17.49 spid54 ...