Viewing 15 posts - 43,171 through 43,185 (of 49,571 total)
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...
November 12, 2008 at 1:38 pm
TRACEY (11/12/2008)
Oh someone changed it to FULL Recovery mode - oh that may do it if your not backing up logs every x minutes.
That would make the log grow, it...
November 12, 2008 at 1:20 pm
Animal Magic (11/12/2008)
November 12, 2008 at 1:19 pm
Animal Magic (11/12/2008)
November 12, 2008 at 1:17 pm
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...
November 12, 2008 at 1:05 pm
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...
November 12, 2008 at 12:04 pm
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...
November 12, 2008 at 12:00 pm
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...
November 12, 2008 at 11:56 am
Can you post the execution plan please? Saved as a .sqlplan file, zipped and attached to your post.
November 12, 2008 at 11:39 am
The_SQL_DBA (11/12/2008)
Are you running low on disk space? if so then DB shrink is good.
Shrink DB is not good. Getting more drive space is good.
Shrink is what you do...
November 12, 2008 at 11:28 am
m.dunster (11/11/2008)
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...
November 12, 2008 at 11:26 am
m.dunster (11/12/2008)
bump
No need to bump every couple of hours. This is a forum, not a chatroom.
November 12, 2008 at 11:18 am
Mike Levan (11/12/2008)
is there any alternative we can do for...
November 12, 2008 at 11:17 am
Is there a firewall between the two servers? Ask your network admin if you're not sure.
November 12, 2008 at 11:12 am
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...
November 12, 2008 at 8:21 am
Viewing 15 posts - 43,171 through 43,185 (of 49,571 total)