So, what about starting over from scratch?  I have done this numerous times going from one server to the next (all same versions-OS/SQL) as well as upgrading from different versions...

have you run a "sp_configure" against both machines (with advanced options, of course)  and compared?

ensure everything makes sense

Sorry if I missed it in the previous posts, but did you go into SSRS Config Manager and change the database connection to point to your new server?

I...

It will have negligible impact.  These are backups of the transaction logs.  Transaction logs are broken into VLFs (virtual log files) which are many mini buckets within the transaction log...

That was the first thing I did on day 1 here.  The application was extremely slow.  The MAXDOP was set at 0, so a query would come along and grab...

Thanks, Jeff
Our DEV box has 2 CPUs.

I am completely on board with everything said.  My issue is we have a C# development team who have been tasked to begin writing their own TSQL.  But neither I,...

Check all statements from the app, not just RPC.  There could be a rollback.  Is this in an Availability Group?  Does the app's connection string have a READ_INTENT=TRUE?  Does the...

Thanks

I have that hanging in my bedroom already.

Yeah ... right.

Maybe I can hang it in my bathroom ... hmmm ...

The user is in a security group and all of the users in that group are experiencing the same thing.

Yeah, not when the user can script the indexes just fine.  Just not the filter.

It is odd. 

It's like the filter is part of some slightly...

The filter_definition is NULL, but when I run it, it has the WHERE clause.

I know, crazy

Thanks, Grant.  Found it.

DBCC OPTIMIZER_WHATIF

Great tool to use, especially with...

No, that just tells a query it's OK to use additional processors in parallel if it thinks it needs them.  What I am talking about is if your development instance...

I have had the need to do this as well.  As Aaron points out, referential integrity will need to be maintained in order for your subset to make any sense.