use bulk insert in combination with bulk logged recovery model

Keep in mind changing the recovery model will affect your DRP !

Your update trigger needs to be firred !

Then you can check the update content.

CREATE TRIGGER tr_CallDetail ON CallDetail

AFTER UPDATE

as

Begin

if UPDATE (callnumber)

begin

-- this means the callnumber column...

Regarding FK:

- Many people forget to create supporting indexes for their foreign keys (so in the child tables ! ) ! Resulting in full table scans (every time and again...

Matt Miller (4/2/2008)

---

Well - there IS a way...but it's usually worse than the cure. You'd have to go querying Information_schema.columns for the "sequence number" of the column, and use...

Well, in case of large data-transfer I especialy would dislike using the clr.

Your sqlserver instance is at risk !

Check my reply on Jeff's article "Solving the "Running Total" & "Ordinal...

Thank you Jeff for the proformance comparison :rolleyes:

Especialy in that case ( it's only a neglectable difference) I'd prefer the use of the cast or convert, just to avoid implicit...

- for starter : avoid clr as much as you can !

- Consume webservices ? Remind your devs that webservices may be down/offline/overloaded/.... So not available

How would that relate...

keep in mind the output may varry according to your input parameters (check bol)

Can you post your exact statement ?

Indeed it gives an error, but the temptb is being filled...

create a #tmptb according to the output you expect (check BOL !!)

then just perform

insert into #tmptb

exec sp_help_job

"et voila" you have the results in the temp table.

- Did you provide the needed indexes to process your tables ?

- Bol has nice info regarding partitioning.http://msdn2.microsoft.com/en-us/library/ms191174.aspx

- and off course there is still Kimberlys must read WP http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

Jeff Moden (4/1/2008)

---

You don't need any of the CASTs...

SELECT DATEADD(mm,1,EndDate+'01')-1

FROM (

SELECT '200812' AS EndDate UNION ALL

...

you can use ...

if object_id('dbo.yourtable') is not null

begin

drop table dbo.yourtable

end

Keep in mind this is not a best practice because you need elevated auth to be able to drop...

Nice article.

- I'd move the tables to msdb because they "belong" to the job system of your sqlserver.

- Since security is your main concern, I'd avoid the use of "grant...

you are usingn the @BCClist for as well the @To as the @BCC parameters !!

Only use one of both parameters to start with.

CREATE PROCEDURE dbo.proc_happyBirthday2

AS

BEGIN

...

Indeed, changes to the underlying table's column order will make a bitmapped trigger buggy, and there is no way you can avoid it becomming buggy ...

Best is to seal it...