Good catch, Perry.

That is indeed fundamental !

just to add to the solutions that have been posted already.

The term "primary key" comes from the concept of data analysis (normal forms, ...).

It determines the attribute(s) [columns] that uniquely...

isn't that a somewhat heavy laptop ? 😀

Nice examples.

IMO for a very temporary solution it still may be tolerable ... to use a hybrid solution

CREATE function ufn_GetOrderDetailsCombinations ( @PurchaseOrderID int )

returns table

as

return (

/*

Select...

Best is to just read about it in Books online and then perform a test using the Database mail configuration wizard of SSMS.

Here's a nice setup ref: http://www.sql-server-performance.com/da_email_functionality.asp

Here's a little...

The question is also the same ...

Is your goal High availability and/or Data loss protection ?

Do you want no application modification impact (connection string) ?

Do you want no application modification...

Carl Federl (4/12/2010)

---

With the SQL Server Configuration Manager open, expand "SQL Native Client Configuration", right click the 'Aliases' in the tree, and choose 'New Alias'. There are...

lauer_Christopher

I have added a reply to the thread Elliot_W mentioned.

so .... picture this ..

Physical server name TheServer IPaddress 172.16.6.10

The instance TheServer\TheInstance listening at port 2072 (double check its usage if you actually want to use this particular port number...

just set up a dbmail profile to be able to send emails, and then schedule a sqlagent job to launch your emails.

You can either put your sqlscript in the sqlagent...

Thank you for the feedback.

It's nice to see the different solutions and how they actually performed in your case.

IMHO in many cases, queries will have a big performance gain if...

What is your goal with this/these DRP ?

Microsoft SQL Server 2005 has a number of ways that can help you.

- Failover Cluster (shared storage)

- Database Mirroring

- Database Replication

-...

just a quick first impression on the original view

I would rewrite that one to avoid as much IO as possible ... so use (not) exists as much as possible

WITH ...

What service pack is your sql2005 on ?

Please post the result of

select @@version

or

Select Serverproperty( 'ProductVersion' ) as ProductVersion

, Serverproperty( 'ProductLevel' ) as ProductLevel

, Serverproperty(...

You have explained your concept, but ... can you provide DDL and some execution statistics of your tests ?