rajemessage 14195 (7/27/2015)

---

I got the point,

q1) that means if population is going to be whole number with out fraction.

that is converting using cast( '323' as decimal ) is write, because...

No. Until a full or diff runs.

SQL's not going to change the setting automatically. Windows updates aren't. That leaves someone changing it or some job or application you have that's changing it.

The setting only takes...

Someone's changing it, or a job is changing it. Since the setting only takes effect at restart, you see it after a windows restart. Ask the people with administrator access...

andrew gothard (7/27/2015)

---

Never? What if one of the untrusted constraints...

For whatever reason (probably bad data), they've just created them WITH NOCHECK. It's not going to cause performance problems.

The advantage is that, if you're in full recovery model and know how to do piecemeal restores, you can restore primary very, very fast (it's only the system tables) and...

Always specify your required precision or length. The default isn't 0, the default is DECIMAL(38,18), which is huge.

Cast either (or both) the numerator and denominator to DECIMAL of the required...

You'll need profiler or preferably extended events. You could probably do it with agent alerts as well, but I wouldn't recommend it. The volume of email will be spectacular.

Messages with...

To be honest, that whole section on locks looks questionable.

The recommended practice for SQL Server is to leave that setting at default (https://msdn.microsoft.com/en-us/library/bb402936.aspx). It's checked by one of the...

When you have duplicate indexes, all of them will show...

INSERT INTO vacationaccrual

(empno,

accrued_vacation,

accrued_sick_effective_date,

...

I need to count the machine only once, in the first month that it was serviced and ignore it from then on for that year. Any other services are...

Preallocate the what????

If he's talking about the 'locks' server config setting, tell him to keep his hands off it unless he can explain exactly what it does (limit the maximum...

You can get the actual plan from when the application runs it with a server-side trace. You can run it manually within a transaction and roll it back, make sure...