I see the same thing on SQL 2000. Interstingly, I still see only one 100% cost, touching ul2 on SQL 2005.

Upgrade to 2005?

Hi Greg,

Looks like this partitioned view is going to be the death of you .

I've take your sample code and created the tables and...

Your list of tables is the tables you can see in Mgt Studio. You'd then need to assign permissions to each table individually.

Or you could use T-SQL. Generally,...

I think MS made it awkward and difficult to force users into using T-SQL. Which isn't a bad thing necessarily .

In Mgt Studio:

1)...

Hi David,

Just to double-check: Did you change the return datatype of the function to char(10)?

If so, it must then have to do with how your procedure is handling the...

David,

when converting it back to datetime, you should specify the style you want as well.

In fact, if you want it returned as a datetime format you just convert it to...

David,

you'd need to use the convert/cast function and specify what style you want the date to be in.

e.g.

RETURN convert(varchar(10),dateadd(day, -1, datediff(d,0,@today)),103)

Style 103 corresponds to dd/mm/yyyy. The different styles...

Oops,

try this.

delete table2

from table2 t2

where not exists (select 1 from table1 where description=t2.description and referenceID=t2.referenceID)

Andy,

Try using the EXISTS clause instead.

like so:

delete from table2 t2

where not exists (select 1 from table1 where description=t2.description and referenceID=t2.referenceID)

Hope that helps,

I did wonder why you were worried about a 0.1 second difference .

Even so, the 10 seconds difference shouldn't imply that it is scanning...

Greg,

Obvious question but is the CHECK constraint on the partitioning column disabled? Just thought I'd as just in case.

I can't really explain why it would ignore the partitioning column...

Hi Janice,

try this: "exec pListOfMembers".

You don't select from a procedure in the same way that you can from a view. With procedures, you just execute them.

Hope that helps,

You shouldn't be doing this with a cursor.

The first method you were using was the correct method:

INSERT INTO ACCEVENTIMPORT

SELECT * FROM _ACC

The order of rows in the table ACCEVENTIMPORT does...

Mark,

you should be able to set up a monitor server on standard edition. I just checked, and standard edition comes with various log shipping procedures in msdb, including sp_add_log_shipping_monitor_jobs,...

You know, I could have sworn that fn_get_sql returned the very last statement that executed but it looks like I was wrong.

I must have imagined that. Sorry.

Yeah, the dynamic...