You can add and use Access as linked server but only if your Office installation is a 64bit as SQL Server is.

EXEC sp_addlinkedserver

@server = 'AccessTest'

,@provider...

Try to make a log of the executions/SPs in order to locate your issue. It seems the executions order and theirs finishing times are important in your case.

D.Schrenker (12/5/2013)

---

I will preface this by stating we are using MS SQL Server 2008 R2.

We're having issues when our database backups are running SQL Server takes all of the...

How is your set up in the sys.sp_configure?

you can run this for any case:

exec sys.sp_configure 'show advanced options',1

reconfigure with override

go

exec sys.sp_configure 'xp_cmdshell',1

reconfigure with override

go

Regards

IgorMi

Hi

You can use the performance monitor (perfmon.exe) by choosing "Log growths" and "Data file(s)" under the MSSQL$Instance:Databases for a specific database.

Regards,

IgorMi

GilaMonster (12/2/2013)

---

You have to alias table variables, and wrapping the table variable name in [] tells SQL that the table in question is a real table in the user database...

Hi

You have data conversion incompatibility. Check what are doing your "Data conversion" and "OLE DB Source" components and whether it corresponds to the respective data types of the columns in...

Carlo Romagnano (12/2/2013)

---

It's wrong because...

PiMané (12/2/2013)

---

IgorMi (12/1/2013)

---

RSCI will increase a lot the usage of the tempdb. You should have ready tempdb.

Did you make indexes analysis? Aren't there a lot of missing indexes?

How about queries,...

RSCI will increase a lot the usage of the tempdb. You should have ready tempdb.

Did you make indexes analysis? Aren't there a lot of missing indexes?

How about queries, are they...

All options are true except this one

"CREATE CLUSTERED INDEX IDX_A ON #temp1(i,a)"

You should correct your question.

Hi

The increment of an identity column (user_id) is not rollback-able. So if you're having rollback transactions than the seed value will just go forward.

Regards,

IgorMi

One mistake is the overdozed usage of cursors. In most of the cases cursors can be replaced with set-based statements.

One another mistake is the implicit conversion in queries because of...

Koen Verbeeck (11/26/2013)

---

IgorMi (11/26/2013)

---

Hi,

These settings I've done on a client machine with RAM of 128 GB were following:

max server memory set to 112 GB

min server memory set to 64...

Hi,

These settings I've done on a client machine with RAM of 128 GB were following:

max server memory set to 112 GB

min server memory set to 64 GB

My suggestion for...