Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 9
Newest
 Teacher
Impact
~9k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Jan
26
accepted How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
Jan
17
awarded  Teacher
Dec
23
awarded  Popular Question
Dec
17
answered How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
Nov
25
comment How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
Yes i've also tried to add permissions on the folder where the .mdb resides.
Nov
25
awarded  Commentator
Nov
25
comment How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
I tried to add permissions to the TEMP folder without success. If i add the user to the Administrator group, it work (only for an AD user, not SQL Server user)
Nov
25
revised How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
added 4 characters in body
Nov
24
revised How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
added 683 characters in body
Nov
22
revised How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
edited tags
Nov
22
revised How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
added 97 characters in body
Nov
20
asked How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?
Jun
17
awarded  Notable Question
Nov
21
awarded  Popular Question
May
3
accepted What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
May
3
comment What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
We havent developed anything yet. Everything is fresh on SQL Server 2012. So i guest the best bet is to use the newest configurtion everywhere.
May
3
asked What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
Apr
22
awarded  Scholar
Apr
22
accepted import csv data stored in a blob column
Apr
22
comment Best practice for tempdb log file
i havent done any performance testing. I just wanted to start with a good setup and i took what others gurus are recommending for that. It's like if we are talking about installing SQL Server on a single drive vs seperate drives for the UserData, SystemData and tempdb. I'm pretty sure that i will not see a difference for the firsts months but in the long term, it's clear that it is better to have a disk strategy. So this is why i was asking about ideas on how to configure tempdb log data.