you can automate it - but depending on your volumes and what you do with the partition of over 90 days you may have performance issues.

assume a weekly process.

current table...

Few questions.

As you are considering partitioning I assume you are on Enterprise version.

When you say a few million is that 10, 50, 100, 500, 1000?

Is the table modified by that...

arkiboys (8/17/2016)

---

Hello,

using a combination of ssis and C#, we are placing file data into sql server tables.

The files contain around 70 million of rows...

We can not use bulk insert as...

I think that message is not directly related to "always on encryption".

Microsoft SQL Server Native Client Version 11.00.2100

Running connectivity tests...

Attempting connection

Connection established

Verifying option settings

INFO: Data encryption was enforced by server...

try also searching for the hex version of vb.

select * from sys.sql_modules

where definition like '%7662%'

Most malware I've seen on sql server execute a hex version of the code which gets...

Is that deadlock related to the remote server or local server? being that you are updating the local server I would expect it to be related to local resources, not...

try and do a repair of shared features of your 2016 install

have you tried this ? http://www.microsoft-sql-ssis.com/2015/09/how-to-create-and-use-temp-tables-in.html

SSDT will install with a visual studio shell - no need to get a full version of visual studio just for this.

The following may help if the truncation error is on the load to the final table - http://www.sqlservercentral.com/Forums/Topic1300952-364-1.aspx

if the error is on the input file itself then changing...

as I am also a Oracle/DB2 person I have used these a lot in production - and the current projects I am working on 2014 will use them also.

...

different collation between instance, tempdb and other databases is not a problem but it does require that the code is aware of it and deals with it.

Not doing the code...

try

if object_id('sp_GetDiskSpaceStats') is not null

drop procedure dbo.sp_GetDiskSpaceStats;

go

create procedure dbo.sp_GetDiskSpaceStats

as

begin

set nocount on;

if object_id('tempdb..#tmpFileList') is not null

...

time to put more memory on that machine.

there can be several reasons for that low value to show up now

- more data on tables

- bad sqls processing lots of...

and you may also consider moving to the a runtime

2013 - https://www.microsoft.com/en-us/download/details.aspx?id=39358

2016 - https://www.microsoft.com/en-US/download/details.aspx?id=50040