inserted isn't a real table. It's a pseudo table that's materialised for the duration of the trigger (only) with the values of the rows that have been inserted/updated.

Is there a...

I dream about the day of right clicking a table and choosing "defragment." This wonderful built in utility would then return my table to it's initial fill factor and clean...

Can you post the execution plan please? Saved as a .sqlplan file, zipped and attached to your post. My guess is that it's because the NC index on the detail...

Can you post the execution plan please? Saved as a .sqlplan file, zipped and attached to your post.

Shrink DB is not good. Getting more drive space is good.

Shrink is what you do...

m.dunster (11/11/2008)

---

Hi Guys,

I am trying to advance my very basic sql statement knowledge.

Looking at Select statements, there are two things I want to try and achieve.

Firstly, is cross table referencing...

No need to bump every couple of hours. This is a forum, not a chatroom.

Mike Levan (11/12/2008)

---

Many DBa's say that shrinking is a bad idea, but that is what we do to gain disk space every time.

is there any alternative we can do for...

Is there a firewall between the two servers? Ask your network admin if you're not sure.

Please rather create new threads for new questions.

There's no easy way to see the time stamp. The way you can do it is to roll the log forward second by...

It's not possible to delete threads. You can either report it and ask the mod to delete it, or edit it and put a link in pointing at the correct...

Max bcp threads is for the snapshot agent and is concerned with how many threads are used to generate the snapshot. It's got nothing to do with the log reader...

Please don't cross post. It just wastes people's time and fragments replies.

No more replies to this thread please. Question has already been answered - http://www.sqlservercentral.com/Forums/Topic600722-145-1.aspx

And please don't cross post! It just wastes people's time as they answer questions that have already been answered.

No more replies here please. http://www.sqlservercentral.com/Forums/Topic601230-146-1.aspx

Don't backup to a network drive. It's slow and if the network glitches the backup will be useless. Backup locally and then copy the backup to the network drive.