Cool!!! After I changed to 'TextData VARCHAR(8000)' it worked. Thanks smart people.

doesn't tell me that, I posted the error

Thanks guys.

Thanks yb751. Now I get sizes of all databases, this also helps. Now, Is there a way to get only 'Adventureworks' database size (instead of inserting all databases in the...

Thank you!!!

Update:

It 'log space used' went down to below 10% after it reached almost 70%. didn't find any open or log running transactions!!!!

Thank you guys for your reply. One thing to mention here my Prod database has Log shipping configured for every hour but when I run sys.databases, it shows 'Log_backup' on...

Go to task manager, Click Performance, whatever no. of boxes you have under 'CPU Usages History' you have that many logical CPUs to run parallel queries.

Isn't that right GilaMonster?

if you run: SELECT PolicyNumber FROM tblAlternateReferences WHERE [SourceSystemId] = '123'

it will do a index seek. I think it is sorted by 'SourceSystemId'.

Can you please tell me how did you find looking at execution plan 'Contact' rows are problem?

"The new plan also shows us that the increased number of Contact rows has...

@MadAdmin, when I query:

select object_name(id) as tablename, name, indid from sysindexes

where object_name(id) = 'SalesOrderDetail'

It give me:

SalesOrderDetail---------ix_SalesOrderIdDetailId ------1 (clustered index)

I didn't understand why execution plan suggesting me...

Great!!! Hat's off to you.

Thank you guys!!!

Thanks Alan. Do you think this is the main reason the numbers are high?

Hi Gila,

Don't know if I can add on this thread. let me know for future reference. Anyway just have a question:

my 'Prepared' size is more than 'adHoc'. should I run...