XXXXX_Datad:\program files\microsoft sql server\mssql\data\XXXXX.mdf158972Unrestricted300 MBs

XXXXX_Logl:\program files\microsoft sql server\mssql\data\XXXXX.ldf46002TBS20 MBs

yyyyy_Data1f:\program files\microsoft sql server\mssql\data\yyyyy_Data1.NDF71892Unrestricted300 MBs

yyyyy_Data2h:\program files\microsoft sql server\mssql\data\yyyyy_Data2.NDF107838Unrestricted200 MBs

yyyyy_Data3D:\Program Files\Microsoft Sql server\Mssql\data\yyyyy_Data3.ndf48540Unrestricted200 MBs

yyyyy_Data4f:\Program Files\Microsoft Sql Server\Mssql\Data\yyyyy_Data4.ndf82186Unrestricted300 MBs

yyyyy_Data5h:\Program Files\Microsoft SQL Server\MSSQL\Data\yyyyy_Data5.ndf19776Unrestricted200 MBs

tempdevE:\tempdb.mdf8Unrestricted10%

templogE:\templog.ldf0Unrestricted10%

Have to chk with Network team abt the SAN, RAID .etc in which the DB's reside. will get back ASAP

Its Enterprise edition.

Processors: 8

Max Server Memory: set at 10 GB

Memory: 12 GB

Provided clarifications below:

1. We placed the tempdb.mdf and ldf files in a separate drive.

2. dbcc dbreindex(XXXXXX,'',90) with no_infomsgs

dbcc dbreindex('XXXXXX') with no_infomsgs

Version: 2005 with SP3

Tempdb...

I need to attach the result of an SELECT query as an Excel file in the DB mail. Can that be done? When I give the File name in...

Lowell, It worked like a charm. Thanks a lot.

Still one question; When i attach the results as an .XLS file, it opens as,

COLUMN1 COLUMN2 COLUMN3 COLUMN4

---------...

Lowell, Thanks for the reply.

Apologies. I couldnt check the code. Windows patches and some monitoring tool is being installed in the SQL box.

Will surely get back to you, once...

Hi Lowell,

thanks for the code. But need further help; could you please show where to add your part of code (after makng size/font changes) in my code? I have...

I am assuming that, Auto Update statistics gets triggered when the changes to the table is about 5% (or 20%) of total rows in the table. So, if that condition...

Thanks Gail, Lowell.

So, having "Recompute statistics" to NO, would override the Auto update statistics set for the database?

yes, tried that.. connected SQL 2000 from

SSMS --> Management --> Legacy --right click a specific Maint Plan -->

I have View history, delete, properties, refresh only

Am i doing it...

Thanks for the link. But in SQL 2005, when i right click

Database Maintenance Plans in Legacy, I dont get Migrate, I have only View History.

I am using SQL...

1. how do we save Maint Plan as dts file?

2. Also it requires a lot of manual effort, since we have more than 70 maint Plans

If SSIS can do that,...

Hi,

thanks for pointing to the post. I have the exact situation given in that post (copied below):

Question #2:

One of my packages calls a child package. But I keep getting an...

Hi Jason,

When I right click the package and give execute package, we would not be getting the versions. it starts executing. I was under the impression, that in such cases,...