Viewing 15 posts - 33,631 through 33,645 (of 49,552 total)
You should not be truncating the log files. Either implement log backups (if you need point it time recovery) or switch to simple recovery.
Please read through this - Managing Transaction...
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
March 8, 2010 at 8:39 am
The information you need is here:
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx
I suggest picking up one of the MS self-paced training kits and working through it.
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
March 8, 2010 at 8:35 am
Paul White (3/8/2010)
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
March 8, 2010 at 8:24 am
8 on SQL 2000, 24 on SQL 2005+. 1 or 3 extents. Below that rebuilding the index will just lead to more mixed extents. Above that SQL will use dedicated...
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
March 8, 2010 at 7:11 am
Have you read everything there is about locks and transactions in Books Online?
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
March 8, 2010 at 4:21 am
nadersam (3/8/2010)
for changing to single user i am not sure i could do that on production db.
No. Don't even consider changing a production DB to single user mode. It will...
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
March 8, 2010 at 4:02 am
nadersam (3/8/2010)
The thing i needed to confirm is droping an unused index has no impact on performance
No impact, providing the index really is unused. Make sure that you've monitored 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
March 8, 2010 at 3:59 am
Sqlfrenzy (3/8/2010)
GilaMonster (3/8/2010)
You can drop an index at any time, neither the DB nor the server have to be in single user mode. If the index...
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
March 8, 2010 at 3:44 am
The 1000 pages is a rough guideline for more-or-less where rebuilding an index has a noticeable effect on performance. If you know that you need to rebuild smaller indexes 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
March 8, 2010 at 3:23 am
Yes. When I moved to consulting (a year and a half ago) from a full time position. It was almost 6 months before my income matched monthly expenses and I'm...
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
March 8, 2010 at 3:14 am
Please don't automatically drop indexes that show low seeks/scans. That DMV is cleared whenever the DB is started, so if SQL is restarted often that will not show complete information....
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
March 8, 2010 at 3:13 am
They you're going to have to depend on licensing and legalities. Once a SQL database is deployed to an instance outside of your control, all bets are off. A sysadmin...
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
March 8, 2010 at 3:03 am
You'll need to script out all the objects, export all the data and recreate the database on SQL 2000.
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
March 8, 2010 at 12:37 am
Please post new questions in a new thread.
Thank you
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
March 7, 2010 at 2:26 pm
sameh.hamza (3/7/2010)
1- Prevent customer from viewing the DB design, creating diagrams...etc.
Not possible
2- Encrypt all views, stored procedures (I know the SQL way can be decrypted, we need another way)
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
March 7, 2010 at 9:16 am
Viewing 15 posts - 33,631 through 33,645 (of 49,552 total)