haiao2000 (10/2/2012)

---

NAH! you aren't missing anything. it was just our requirements...

bteraberry (10/2/2012)

---

One minor point ... even if you decide to use what they've established, you can make the inserts quite a bit more efficient by ditching the cursor loop. ...

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...