Viewing 15 posts - 46,321 through 46,335 (of 49,552 total)
Now this is interesting. Same question from a different person. hmmm. Homework?
http://www.sqlservercentral.com/Forums/Topic509017-360-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
May 30, 2008 at 7:32 am
Interesting. How come another member has posted the exact same procedure (but different name) with virtually the same question?
See here: http://www.sqlservercentral.com/Forums/Topic509053-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
May 30, 2008 at 7:30 am
There is no where near enough information...
Please post the following:
The table structures
The index structures
Some idea of the volumne of data in these tables.
The current execution plan (saves as a .sqlplan...
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
May 30, 2008 at 7:27 am
Help you with what? There is no where near enough information to give you any suggestions.
Please post the following:
The table structures
The index structures
Some idea of the volumne...
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
May 30, 2008 at 7:22 am
Shrinking database = really bad idea. The DB will just grow again and you will probably have messed the performance up doing the shrink.
Do you have transaction log backups running?
In...
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
May 30, 2008 at 4:34 am
You did notice that the post you replied to is over a year old?
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
May 30, 2008 at 3:54 am
The transaction log is not optional. It's used by SQL to keep a permanent log (for recovery purposes) or all data modifications that occur. It's what allows SQL to always...
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
May 30, 2008 at 3:49 am
Shouldn't be a problem, providing you don't create unique indexes that don't exist in the publisher.
If the subscription is reinitialised, you'll have to recreate the indexes.
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
May 30, 2008 at 2:53 am
What recovery mode is your database in?
Are you running regular log backups?
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
May 30, 2008 at 2:49 am
You don't want to physically shrink the transaction log. It'll just have to grow again.
Since you're in simple recovery, run a checkpoint at regular intervals between your inserts. In simple,...
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
May 30, 2008 at 2:48 am
dlarsen (5/29/2008)
i didn't remove or change anything.i can copy by cmd and i can't do it through Query Analyzer
Copying by cmd uses your account. Copying through QA uses the SQL...
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
May 30, 2008 at 12:29 am
You could install developer edition rather than standard. It's cheap ($50) and will full enterprise features, just not for use in a production environment. It installs on Vista and XP...
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
May 30, 2008 at 12:20 am
Not that I know of, but on SQL 2005 (which I assume you're using because of teh forum this is posted in), you can enforce password policy which includes 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
May 30, 2008 at 12:18 am
Express does not include SQL agent.
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
May 30, 2008 at 12:16 am
Warren Peace (5/29/2008)
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
May 30, 2008 at 12:15 am
Viewing 15 posts - 46,321 through 46,335 (of 49,552 total)