SchemaNameObjectName

------------- ------------

dbo ...

Grant is right use this query to find the name of the schema owner: SELECT ss.name as SchemaName, so.name as ObjectName

FROM sys.objects so

join sys.schemas ss on...

Please read the article in my signature about posting questions. We will need some sample tables and sample data to test our solutions. Thanks

After reading the problem the issue is...

I don't use MPs all that often, so I haven't seen this error before, but have you checked sys.objects if this table "exists"? select * from sys.objects where type =...

The error has to do with the fact that it is now a CTE and is returning YesNoDesc field as something else. Try thisWITH CTE AS(

select case atr.Race

when 32 then...

Is there an issue with the query or are you just wanting to know how to make this a job that exports an excel file?

If the query works and you...

Thanks for the update Markus.

Do you have a storage admin to go to? and have you and the admin followied the EMC best practices? http://www.emc.com/collateral/white-papers/h12341-sqlserver-bp-wp.pdf

I would start with their recommendations (which are usually very...

What kind of storage do you have i.e. SAN, locally attached, etc.?

The reason that you are seeing the SPID blocking itself is because the process is running in parallel. The PAGEIOLATCH is waiting for a data file page to be read...

That is what DBCC CHECKDB is doing, so try it for yourself and see if you get an error. If you succeed in creating one you can try to run...

Do you get the same error if you create a database snapshot on your own?

Are you experience issue currently? or just seen the number and was wondering?

This is not enough information for us to say is they are too high or not. This is...

sqlbuddy123 (3/14/2014)

---

No it's won't be of any good use as you are doing this Off-Hours .. You should try to get metrics during the busy part of the day to...

The easiest way to do this is to use a where clause based on your partition function. Say you used a date based function say on month you can use...