155 reputation
18
bio website
location Quebec
age 33
visits member for 2 years, 2 months
seen Dec 17 at 16:01

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.
Apr
19
comment import csv data stored in a blob column
@JobSeigel: Because we can't update the stats that is shown on the website during the day. It must be during the night. But can you give me some insight on how to use a queue? It might be interesting.
Apr
18
comment Best practice for tempdb log file
you're right. I guest i should leave it on. I have corrected a few flaws in my text too :)