this will show you everything, which includes all the objects in the default partition, and the commented out WHERE statement will show you the objects that exist in other partitions,...

SVR (11/7/2011)

---

thanks for your response.

The problem was , got a request for data refresh from prod to test, some of them were views. did not know how to refresh view...

It's all permissions, of course, so i believe you need one of two things: either add every login as a user to the msdb database(or at least the ones that...

I have one client that put their database in case sensitive collation prior to running the installation scripts;

our app has a typical search screen kind of thing, so the search...

what is the real name of the database trigger?

it looks to me like you keep running the script on the placeholder name [database_trigger] instead of the real trigger name...TR_Whatever_Insert or...

anthony this is just a guess, but it might work:

it's possible to map a network drive, and include the username/password to use[impersonate] the permissions for it;

i've done it with xp_cmdshell...

Glad i got you pointed in the right direction;

If you can use CLR, i think there's a couple of ways you could do it that way; I had a Web...

Pretty sure sp_OACreate is limited to an NVarchar(4000) max parameter;

I had written something in SQL 2000 which harvested web pages, and had to grab slices of the results from my...

well, the part i was trying to talk about was the screenshot below; see the difference for the "good enough plan found" vs the other that did not find a...

i had to use winmerge to be sure, the two files you posted are identical; could you have copied the same plan as two different names?

Cadavre I love how you add the million row test harnesses to your examples...

I may start adding that to some of my posts as well in the future.

Thanks buddy!

mikes84 (11/4/2011)[hrLowell,

So are you saying that this type of comparison, row over row (as in the EXCEPT clause and my second example):

Table 1 fields

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

Table 2 fields

is usually better than this...

in 2008 and above, i think the expectation is to start switching over to CLR;

here's the CLR equivilent of xp_GetFileDetails:

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Imports System.IO

Namespace Enterprise.SqlServer.Server

...

i think you want to look at the EXCEPT operator;

if all the columns are the same, it might look like this:

--find what doesn't match from Table2

SELECT PK,ColumnList FROM Table1

EXCEPT

SELECT PK,ColumnList...

A couple of Grant Fitychey's presentations he did on execution plans might be relevant;

as i remember it, the key to look for is the property "Reason For Early Termination of...