Jeff Moden (3/24/2015)

---

As for the padding thing in the BTREE, that's done during an index rebuild using the "WITH PADDING" option. Note that it will not help performance...

Wayne West (3/26/2015)

---

.....

How do you argue that you want as many spindles as possible to separate the DB, Log, and TempDB from each other to maximize performance when everything...

Wayne West (3/25/2015)

---

I'm confused. How is changing the indexes supposed to resolve an issue with an increase in table space?

And man, you have my sympathy! Oracle -> MySQL...

Jeff Moden (3/24/2015)

---

Shouldn't...

Jeff Moden (3/23/2015)

---

.....

And now for the black arts part of all this. If you're going to do offline rebuilds anyway, consider disabling the index first. That effectively removes...

Alan.B (3/23/2015)

---

My apologies - I misread you original post a little. I was under the impression that some of these indexes were 10% fragmented weekly, not more than 10% as...

Jeff Moden (3/23/2015)

---

Almost forgot. You can also "pad" the BTREE with the same fill factor. Again, that would be a judgment call and should not necessarily be a...

Jeff Moden (3/23/2015)

---

Just to add some information to this thread.

.....

To get back to fill factor once again, if it's a real problem on some indexes due to inserts, consider building...

Alan.B (3/23/2015)

---

10% fragmentated indexes should be reorganized, not rebuilt; the MS recommendation is to rebuild at 30% or more. Also, depending on the size of the indexes re-org's or rebuilds...

DKY (3/17/2015)

---

Attached is a smaller version of the file that I'm using. I opened it in notepad++, edited it and saved it as a .txt file so I could...

Nice article Dan. I understand the Pain you mention of RBAR triggers all to well. We have an OLTP database that uses 7 of them to trigger EDI...

Grant - I love this article and you are spot on correct.

However I have never read anything that made me think of Star Wars II so much.

You know the quote:...

Ed Wagner (3/12/2015)

---

DKY (3/11/2015)

---

So, my other option. If I just import the file into one columnCREATE TABLE BULKACT(RAWDATA VARCHAR (MAX))

BULK INSERT BULKACT FROM 'C:\ftp\NAV830.curr' then I can only import...

cookie SQL (3/9/2015)

---

I would look at the active portions of the log 'DBCC LogInfo' , check that its viable to shrink or it will just fail.

The other thing not mentioned...

I see it as great replacement for desktop edition.

Helped several people ditch other Open Source SQL solutions for SQL Express.

The current versions very robust for a free product.