What do you see under database mirroring monitor?

MJ

Check Example 1: VBScript to delete files in a folder that are certain days old

under

http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/

MJ

You might have chked-->

http://www.sqlservercentral.com/Forums/Topic584519-357-1.aspx#bm584538

MJ

Attached doc might help.

MJ

Check --> http://www.sqlservercentral.com/Forums/Topic641421-146-1.aspx

MJ

Analyze the execution plan of the query and see if indexing can be of help here.

MJ

You will get it from sys.dm_db_partition_stats

select * from sys.dm_db_partition_stats

where object_id='Enter the ID here'

and Index_id='Enter the ID here'

MJ

I tried what you said in 2005 and it worked too. I followed what has been stated in http://www.sqlservercentral.com/scripts/T-SQL/63398/. Please try again and it wll allow you to restrict column...

State 8 pops up in case of password mismatch.

MJ

Might be the rest of the memory is getting utlised by OS or other applications running on this server. I would suggest you to use /3GB switch.

MJ

For heaps obviously you won't be able reduce fragmentation without going thru the complete cycle of creating a clustered index on the heap and then rebuilding or reorganizing it based...

Try this:

Create TABLE #db_file_information(

fileid integer

, theFileGroup integer

, Total_Extents integer

, Used_Extents integer

, db varchar(30)

, file_Path_name varchar(300))

-- Get the size of the datafiles

insert into #db_file_information

( fileid

, theFileGroup...

You need not execute sp_updatestats after rebuild command as it gets executed in background by this command. Index looks to be of very small size but if you still want...

sp_get_composite_job_info (loading in a bunch of NULLS, and a “1” to indicate running jobs):

Run-->msdb.dbo.sp_get_composite_job_info NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL

MJ

For 32-bit installations, the use of address windowing extensions (AWE) memory has been improved so that SQL Server 2005 Standard Edition can use more than 3GB of RAM. Also, with...