Yusuf Ali Bhiwandiwala (3/27/2013)

Hi Vedran,

I couldn't quite connect your two sentences:

"Heaps should have no indexes" (heaps can have non...

insert into error(a, b, c, d, e, f, reason)

select u.a, u.b, u.c, u.d, u.e, u.f, reason='not in member'

FROM util u

join

(

Select a, b, c, d from util

Except

Select a, b, c, d...

Nulls will be the problem because you use = operator. Use except operator, it gives correct result and is much simpler:

Select a, b, c, d from util

Except

Select a, b, c,...

Defragmentation and high fill factor (default 100), so there will be less pages to read. Optimize disk read speed (put their filegroups on RAID5) and network speed (check that networking...

Heap should have no indexes. Try with TABLOCKX hint.

Google "Brent Ozar", read his articles and watch videos. There are very few counters that have some absolute limits, like cpu queue, disk secs per read, secs per write. All...

You do not need a view for delete-insert command. Making the code even simpler:

INSERT INTO destination

SELECT *

FROM

(

DELETE TOP (100)

FROM source

OUTPUT DELETED.*

) AS t

Complete example:

use tempdb

GO

-- prepare test data to transfer

select...

Here it is, with a bit more explanations:

http://blog.sqlxdetails.com/procedure-with-execute-as-login/[/url]

I'm glad to help. I'll put the script and explanations on my blog.

Name it as you like. Yes, it can be classified as a type of slowly changing dimension, but the name is not really important here. Is that functionality you need...

Yes, solved it with start-end dates and cte packed into a function (instead of...

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ac074ccb-1a52-4bda-a032-c874d3ba8ce5/[/url]

cmd.Parameters.Add("@Value", SqlDbType.Xml).Value = doc.ToString();

Try using "new SqlXml(...)" instead of converting doc to string.

Never delete. On move, set enddate instead, and copy to new location with startdate=enddate+1. Add date filter to queries.

Intermediate results sometimes can be calculated separately and stored to temp tables. Post your cte if you want more specific answer. There is no debugging tool that i am aware...