an alternative (if you can't use the view because it points to a linked server) is to use transactional replication and update the table in small chunks, rather than a...

Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP instead

again -...

Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP instead

again - sorry jeff,...

It’s interesting to think about developer time when it comes to the top two results: the “freeing up developer time” isn’t simply about allowing them time to code more changes which are delivered more...

I think you hit the nail on the head when you used the word MERGE  - are you familiar with the command?

my 2 cents on this - why are you truncating a table and replacing it with the view data. - why not just reference the view?

I did not know this... are there any ms documents around it?

I assume that you are using one of the sql spatial types for this ? if so then make sure you are using the geography type and not the geometry...

I normally use ROWNUMBER() over (order by x partition by y) - usually because It involves finding the first order of the day for that product type (partition by product...

##csvtemp only contains  6 lines.. so it is not big...

set @sql = 'bcp "SELECT Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15,Col16,Col17,Col18,Col19,Col20,Col21,Col22 FROM ##csvtemp" queryout '+@processedFolderLocation+'/"'+@csvFileName+'" -c -d ' + DB_NAME() + ' -t, -S '+...

you don't have to restart the server,  you can just run "kill 1154" (in this example)

we would need to see both proc calls, but I suspect that since you are...

Sometimes SQL Server underestimates the work you’re about to do, and doesn’t grant you enough memory. Say you’re working with a table variable, and SQL Server only estimates it’ll find one...

email the webmaster at SQLservercentral

Answer: Don't have the systems override the driver. Have them inform the driver instead. Then they can learn from the driver and eventually, perhaps, they'll know enough to be...

then get someone to PM you and verify that you got an email. I smell a virus/malware somewhere