kenambrose (2/29/2016)

---

[[You'll have up to 8 bits to designate just "how" the data is missing. You certainly do NOT want to store 'TBD' | 'NA' | etc. in any column(s).]]

Oh...

MadAdmin (2/29/2016)

---

j-1064772 (2/29/2016)

---

rstone (2/29/2016)

---

I think nulls are used more often than required, but they have their place. If we start with a rule that forbids nulls in the database, then...

Using a single record in a related table to define "missing" or "unknown" is an option that I have seen in use. I thought it resulted in some very...

I think nulls are used more often than required, but they have their place. If we start with a rule that forbids nulls in the database, then we are doing...

Robert, I look forward to the updates. Here is a script to enable the jobs and schedules after a fresh install. It might save a few clicks here...

In the past, I use a tool called ClearTrace to report on the worst of the worst. (I set high limits on the trace reads or writes.) Even...

Robert, I'm running your solution on my desktop. Looks good to me. Added some views for fun. Single values for average MB/sec, IOPS, and stall per database?...

Thanks Robert. I've been using TYPEPERF to collect counters from several servers. It appears that if I want IO detail at the database or database file level, I...

Requirements often don't directly address transactions and locking. Non-functional requirements normally don't specify or limit T-SQL methods. A table that describes the preverbal "it depends" by relating requirements...

The "TOP 100 PERCENT" seems to be ignored by the optimizer. The "TOP verylargernumber" can produce the recordset in the "expected" order. However, this is incidental. If...

I know this is an old post. I can't help but wonder why there has been no response. It's a good question, which is why I'm here. ...

Now I'm more confused. We have 3 new SANs with replication for DR. I don't see how this helps me with point in time restores for a database....

TheAccidentalDBA (8/27/2014)

---

SSC-Addicted nice points and links. I posted two responses separately.Yes, totally agree on your points that its needs to be tested with restore. Logically, the following might work.

1. Only...

SSC-Addicted (8/27/2014)

I don't see any bug with Microsoft here, they offer a 3rd party interface to allow access to SQL backup for integrated backup solutions, but the ultimate responsibility for...

You got the second parameter for the db, so it looks good to me. I think the trace will catch something.

Does the procedure run a long time?...