That is valid, but the order by will not be honoured. Order bys are only honoured by the query processor if they are in the outermost select statement, i.e. the...

That would make the log grow, it...

Animal Magic (11/12/2008)

---

What is happening (and i should have clicked earlier) was one of the statements this app runs is an update with no where clause, every 3 seconds. ...

Animal Magic (11/12/2008)

---

I have a feeling this is what my problem was. the amended table has 6 indexes including the PK clustered index, so the alter table would have...

Yeah, it will. Inserted and deleted will have the same structure as the table the trigger's definied on, excluding some of the LOB columns (I forget which ones)

If there's no...

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