Viewing 15 posts - 43,126 through 43,140 (of 49,552 total)
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
You can't change the frequency. The % of changes that kicks off a stats update is hardcoded. You can update stats manually using UPDATE STATISTICS.
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 13, 2008 at 9:36 am
jcrawf02 (11/13/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
November 13, 2008 at 9:25 am
Try doing an update usage. On SQL 2000 the space use and space available metadata was sometimes inaccurate. Updateusage will fix that.
DBCC UPDATEUSAGE(< Database name > )
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 13, 2008 at 7:56 am
Updating stats won't change the scan density. That's a measure of how much extent fragmentation there is. Stats just contain the data distribution in the columns.
Try a rebuild instead of...
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 13, 2008 at 7:54 am
The_SQL_DBA (11/13/2008)
Place the tempdb on the RIAD 1+0 to increase throughput. Then the data files on RAID 1+0 also. The backups can go to RAID 5.Thanks!!
How do you propose doing...
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 13, 2008 at 7:49 am
Did you set it to multi-user after syncing the logins and users?
SQL won't just set a DB to single-user, Someone would have had to run a command to do so.
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 13, 2008 at 7:44 am
Post the trigger code please, the table structure a couple of example insert statements and what you want Table_2 to look like afterwards.
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 13, 2008 at 7:36 am
Continued here:
http://www.sqlservercentral.com/Forums/FindPost601206.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 13, 2008 at 5:02 am
Not sure I understand you fully.
You have a database on a SQL 2000 server that's giving errors?
Where does SQL express come in here? A different database attached to the 2005...
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 13, 2008 at 5:01 am
You originally posted in in one of the SQL 2005 forums. I asked the moderator to move 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
November 13, 2008 at 4:56 am
That doesn't sound like a login problem. It sounds like a performance problem with that procedure. It doesn't return quickly enough and the front end times out. It may be...
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 13, 2008 at 4:55 am
nazaninahmady_sh (11/13/2008)
i want "Code" automatically increase.
Use an int and make it an identity column.
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 13, 2008 at 4:45 am
Duplicate post.
No replies to this please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic601923-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 13, 2008 at 2:48 am
You've got some nasty database corruption there. I don't suppose you have any idea when that started?
I'm not sure how to fix it. Let me see if I can...
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 13, 2008 at 2:15 am
Amit Gupta (11/13/2008)
You should take differential backup and restore it.
Huh? Why would you want to do that?
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 13, 2008 at 2:03 am
Viewing 15 posts - 43,126 through 43,140 (of 49,552 total)