140 reputation
16
bio website
location Quebec
age 33
visits member for 2 years
seen Oct 1 at 18:30

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 :)
Apr
18
revised Best practice for tempdb log file
added 43 characters in body
Apr
18
comment Best practice for tempdb log file
@AaronBertrand: enable autogrowth on a full sized tempdb will not help. They are already at their maximum they can be on the drive. There's no more disk space that they can use anyway. This is why i have disabled the autogrowth.
Apr
18
asked Best practice for tempdb log file
Apr
18
comment import csv data stored in a blob column
I've added more info about what i need to do. Sorry if it's wasnt clear at first. I appreciate your ideas and i will look at them closely. If you have something to add, don't hesitate!
Apr
18
revised import csv data stored in a blob column
added more info about what's my needs
Apr
17
comment import csv data stored in a blob column
the reason why i want to store the files in the database is to facilitate the backup plan and also because my web site can be installed in 2 differents server (one in the dmz and one internal). If i want my 2 websites to see the files, i need to open a share folder that my dmz will see and im not sure that it's a good idea. And like i said, the backup plan is simpler. What's you tought on this?
Apr
16
awarded  Student
Apr
15
asked import csv data stored in a blob column
Feb
20
awarded  Supporter
Oct
12
awarded  Peer Pressure