Hi there,

the easiest way would be to backup the database where this table is and restore it on the target system. You then have an exact copy of the...

DBAdmin (8/25/2008)

---

In my opinion, this is an almost inevitable drawback of large organizations. In small organizations anonymity is not an option and everybody understands the contributions of others. In large...

EDIT: Damn it, SQLGuru beat me to the punch 😛

Hi there,

jvamvas suggests doing some statistics updates and then index rebuilds.

May I just point out that by doing an index rebuild...

Hi there,

kristen is totally right. If you don't want the world and his dog to see the photo of you passed out drunk at the stag night of your...

fuller.artful (7/31/2008)

---

I totally agree with you, but I qualify my agreement with a measure of the team I'm on, in terms of maturity. Some people, I have learned the hard...

Hi there,

we had a similar situation a few years back when we acquired company XYZ567. I was not greatly involved in the planning, but gave my suggestions to the...

Hey there,

this is me being the good samaritan (a good way to spend some time on a friday afternoon). 😀

I had to change the Audits table - the final column...

Hi,

you say the program cannot be scheduled. Why is that? Is it a GUI driven application that requires user interfacing each time it runs, or have you just not...

Hi Ted,

please don't take the comments as punishment. I think that all comments/questions with regard to your article were to clarify any points that your target audience couldn't get...

On top of these one off deletions there will undoubtedly be cases when such a delete needs to be done. Off the top of my head, I would say...

Hi there,

sorry to (slightly)swerve from the question, but isn't a fill factor of 0 exactly the same as 100 and not almost the same as? I thought I read...

Hi david.gerard,

the idea is that it can be much better to delete in batches when handling a much larger data set than in the example. Imagine you have to...

Hi again,

I just thought I'd give a quick heads-up. The CTE method did beat the pre-table + index that I initially suspected to be quicker.

I also had all of...

Hi RBarryyoung,

I thought about that but wasn't sure what was better, to go the CTE way or to build a pre-table with a better index. I have played with...

Hi There,

I agree that the query would work, but only on the premise that only one of the tables had the column customerid. To say that any of the...