EAV "can" be very fast and efficient if you use it for single-table storage. But that then requires EXTRAORDINARY effort on the application side to handle virtually all of...

I am seriously missing something:

SELECT CAST(5 AS VARBINARY(128)) --0x00000005

SELECT CAST(0x00000005 AS bigint) --5

SELECT dbo.ConvertBigIntToVarBinary1(5) --0x010001

SELECT CAST(0x010001 AS bigint) --65537

Markus (10/1/2012)

---

Thanks for the link SpringTown... I hadn't found that article. I have opened an incident with MSFT and have yet another meeting with the storage gang today. ...

I STRONGLY recommend that you get a professional to give your system a performance review/health check. I am certain there will be quite a few findings that could be...

Agree, as usual, although I would probably phrase it as "highly...

Grant Fritchey (8/27/2012)

---

You might want to hire a consultant to do the interview for you. I know several people that are regularly doing interviews for employers that don't have the...

For concurrency reasons it is MUCH preferred to use MERGE I think. I have seen a number of clients over the years get bad data in their system doing...

Please don't post to 2 year old threads.

Ola.hallengren.com

Best maintenance stuff out there IMNSHO!! 🙂

sunny.tjk (9/11/2012)

---

We've a very large table and I'm thinking to partition it. Either one of these 3 main columns(appid, date or loan_custid) are used in the WHERE clause of...

We cannot help you with so little information. What is the EXACT, DETAILED error message the job that is failing gives?

jeffem (9/17/2012)

---

Eugene Elutin (9/17/2012)

---

jeffem (9/17/2012)

---

CELKO (9/14/2012)

---

By definition it cannot be a key; it is not an attribute of any entity in the logical data model. A well-designed key should have...

1) set database to read only during normal opps. Set it to read/write during your monthly update cycle (when other access is disabled) and then back to read only...

Hmm - " ... that could be applied to secondary".

I think you are missing one or more log files BEFORE the ones that are in the restore directory maybe? ...

Also, can you expand out the restore agent history and get the detailed error message?