Impact, you kill all user connections (by restarting the service) then single user mode allows only a single user to connect.

Small tables would take slightly more space, looking for disadvantages and any effective gains is why you test before enabling in production.

Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Have you tested and seen that the traceflag benefits you and your workload?

You'll need to schedule log backups. Frequency should be based on the RPO of the database mostly and on the volume of log records second.

Please read the book chapter I linked, it explains that and more.

Depends how many tables you have to go through to get that column to filter on.

Yup, that's exactly what it does, truncating the log is the process of marking 0 or more virtual log files as...

Row level security is a nightmare on a well-designed database. Worked on a system once that used it, so much hassle, so much work required.

No. Log backups just mark space in the file as reusable.

Do I...

First thing, set max degree of parallelism back to default or to the number of cores per NUMA node. Parallelism is a good thing. If queries are paralleling inappropriately, fix...

As I said,...

abitguru (3/25/2013)

---

2 - A user can generate a internal requirement, so when I store this on the db, I take next number to save the internal requirement with this number.

3...

abitguru (3/25/2013)

---

Right now I use updlock hint, but this makes a page lock and locks other rows that I dont want to be locked. (others rows that can be used...

Please note: 5 year old thread.