CREATE TRIGGER [DDLTriggerLimitNumberOfDBs]

ON ALL SERVER

FOR CREATE_DATABASE

AS

SET NOCOUNT ON

DECLARE @MSG VARCHAR(500)

...

Maybe something like this:

select a.ItemID, a.ItemName, ISNULL(b.Qty, 0)

FROM Inventory AS a

LEFT JOIN Sales AS b

ON a.ItemID = b.ItemID

This can be useful when performing record linkage and importing data into...

Yea got it thanks. Not sure these sprocs work, I've seen a couple of syntax errors in there. Will have a go but difficult with no sample data.

Fair enough 🙂

Can you post one of the sproc or that part which creates the tables using cursors?

If that's the only use for the cursors then I wouldn't waste your time rewriting them if they already work. I doubt you'll notice much performance difference with a set-based...

Here you go...

p.s.

I got this off the internet ages ago but I can't remember where! Anyway props to the people who compiled it 🙂

Troll :doze:

Have you checked wait stats?

I got into the habit of using the below query for initial investigation into performance related prolems:

This is from Paul Randals blog: http://www.sqlskills.com/blogs/paul/

WITH [Waits] AS

...

Have a read of this: http://msdn.microsoft.com/en-us/library/ms189461.aspx

with SCC_CTE(vend_i, dept, tot_wgt)

as (select 1, 1, 75 union all

select 2, 2, 40 union all

select 3, 4, 50 union all

select 3, 5, 80)

select vend_i, dept from

(select ROW_NUMBER() over (Partition...

From MSDN:

varchar [ ( n | max ) ]

Variable-length, non-Unicode string data. n defines the string length and can be a value from 1 through 8,000. max indicates that...

You're welcome! 🙂

SELECT

Service

,CustomerName

,ConnectDate

,Disconnect

FROM Table1

EXCEPT

SELECT

Service

,CustomerName

,ConnectDate

,Disconnect

FROM Table2

SELECT

Service

,CustomerName

,ConnectDate

,Disconnect

FROM Table2

EXCEPT

SELECT

Service

,CustomerName

,ConnectDate

,Disconnect

FROM Table1

Jeff, thanks so much for your ideas and suggestions. I've spent a few days on this problem and the table has been restructured and a new indexing strategy has been...