murnilim9 (7/21/2014)

---

twin.devil (7/21/2014)

---

If you are loading large data in that particular table where you have created the index, then you can use disable and restore approach which can increase your...

Jeff Moden (7/21/2014)

---

pdanes (7/21/2014)

---

If the disk contains only data files and is 90% full, then you will...

If the disk contains only data files and is 90% full, then you will need a bigger,...

Sean Lange (7/21/2014)

---

How long does your procedure take? I am wondering if your are running into concurrency issues because you have multiple backups being run at the same time. 15...

Interesting article, but there is no explanation of WHY declaring a primary key caused the database to shrink, or why not having one caused excessive growth.

patrickmcginnis59 10839 (6/19/2014)

---

pdanes (6/19/2014)

---

patrickmcginnis59 10839 (6/19/2014)

---

He claims to be out of ideas, and I can't think of what else I might try to help him. Everything works for me, so...

patrickmcginnis59 10839 (6/19/2014)

---

He claims to be out of ideas, and I can't think of what else I might try to help him. Everything works for me, so I have difficulty...

Sean Lange (4/23/2014)

---

Can you simply cast your stuffed column as a varchar?

SELECT VLTO.SkupinaAutoID, cast(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(STUFF

...

So far, it's only in my development system, and I'm trying to learn every aspect of how it works, before I send it out into the real world to fend...

So if the query gives me what I need, I should ignore whatever the design view says? I'm kind of leery about ignoring warning messages - I always wonder if...

OK, that's a good idea, I'll do it that way. The DB doesn't care whether it's a real name, or a delimiter - it'll string it all together regardless.

Not sure...

Okay, I see. I was concentrating on the disadvantages inherent in each method, and didn't think of using both together. It would require manual maintenance of the coherence between the...

Hm, you've lost me. Second table? Do you mean keep the table where I now store the set of records from which the author string is assembled? And another table,...

It's crucial. That's what the ordering field is for.

If it's a VM,...