@@ Toby Harman

Ultimately, adding more memory to the system will only help if

a) SQL can use that memory

b) ALL the relevant data is cacheable

If you can achieve both of...

Hii... Thank you for your replies 🙂 . My buffer cache and page life expectancy are above the threshold limit. SQL is limited to use 8 gigs on this box....

I am using SSIS -> Logging from the menu bar in bids to do the logging. There is no option for db name or server name in those enlisted feilds....

My DB Name is picked by the cursor dynamically. It is not just one database or one instance.. I am running this script using ssis on all sql servers in...

Hello da-Zero

Thank you very much for the quick reply. my package is on sql 08. But, my package will traverse through different servers which includes sql 05. Does this matter?

Also,...

Because, SQL tries to look at different drives, and pull data from different drives which indicates more IOs (May be i am completely wrong!! correct me if I am)

Ali

that was because of space issues with the original MDF...

I thought having mdf and ndf in different drives with different raid levels will cause extra IOs isnt it..correct me if i am wrong!!

i am confused. let's take an example...

Richard,

But when I ran this on my local machine, I didn't get any errors for LOBs. Pleases clarify

Thanks

Ali

Richard,

Even in our environment, we have the same situation. We have LOBS in our database and can't be rebuilt online. I am using the script in this link "http://www.sqlservercentral.com/scripts/Automated+index+defragmentation+script/68802/" which...

The query answered my question 😀

Thanks Guys. This website is being very helpful for me. Even though, I am new to sql, I am able to cope up in...

This query is giving out lot of data.. is there any way that I can consolidate this whole information??

Thanks

Ali

SSMS right click on database--> Properties

Right click on the DB -->...

This will help I guess

DROP TABLE ##TEMPDBID

GO

CREATE TABLE ##TEMPDBID

(

Name sysname,

Db_id_no int,

sidid varchar(5000),

mode smallint,

status int,

status2 bigint,

crdate datetime,

reserved varchar(1000),

categry smallint,

cmptlevel int,

Filename varchar(5000),

Version int,

)

INSERT INTO ##TEMPDBID SELECT * FROM SYS.SYSDATABASES

DECLARE

@query varchar(max),

@Db_id_no...

Following are the options that are checked in the maint. plan

1. Update All exsisnting databases

2. scan type full scan

3. database-- All databases

Thanks

Ali