Viewing 15 posts - 43,156 through 43,170 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 11:18 am
Mike Levan (11/12/2008)
is there any alternative we can do for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 11:17 am
Is there a firewall between the two servers? Ask your network admin if you're not sure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 8:21 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 8:16 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 8:13 am
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 7:51 am
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 7:49 am
Viewing 15 posts - 43,156 through 43,170 (of 49,552 total)