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

first thoughts - DO NOT CLICK ON THE LINK

You could create a table (b_tree) to store your numeric data in a single column.  Then assign additional columns based on common attributes of the numbers.

column1: your numbers

column2: applies...

Anthony is 100% correct - if you are sysadmin then you can just ignore the proc and go and do anything you want.

the proc is a waste of time unless...

if you use a SP for shrinking ,  but your DBA group have sysadmin then they can still run DBCC shrinkfile.

maybe education is the way forward