Viewing 15 posts - 25,936 through 25,950 (of 49,552 total)
river1 (5/25/2011)
My problem is that after some data is inserted this will hapeen again but only for dates above update statistics day.
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 25, 2011 at 7:25 am
river1 (5/25/2011)
I undestarnd but still in 2000 that didn't happen and lthe table has only a few more rows...
SQL 2000 to SQL 2005 was a major change. not a couple...
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 25, 2011 at 7:24 am
SP1 is not available yet, only a CTP (preview) is available. Not something you'd install on a production instance.
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 25, 2011 at 6:32 am
That's not Microsoft Access, that's MySQL.
This is a SQL Server site, you're likely to get better and faster answers on a MySQL forum. Try http://forums.mysql.com
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 25, 2011 at 6:01 am
To move indexes/table to another filegroup
CREATE [CLUSTERED] INDEX ... WITH DROP_EXISTING ON <other filegroup name>
To remove the file once empty
ALTER DATABASE ... REMOVE FILE ...
Read up in books...
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 25, 2011 at 5:59 am
Then you need to move all the tables/indexes from that filegroup somewhere else (rebuild the clustered index on the new filegroup), then run ALTER DATABASE DROP to get rid 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
May 25, 2011 at 4:36 am
I don't have SQL 2000 and I don't have Enterprise manager, but I suspect all that's doing is restoring the log with default location. You cannot delete a log file...
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 25, 2011 at 4:29 am
Enterprise manager? 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
May 25, 2011 at 4:26 am
How are you 'restoring'?
In a restore of a backup (RESTORE DATABASE) it is not possible to remove a log file, or any other file for that matter.
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 25, 2011 at 4:17 am
No. A restore puts the DB back as it was at the time of backup. You can't remove log files during a restore either, they're required for restoring the DB...
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 25, 2011 at 4:07 am
river1 (5/25/2011)
Way is this appening? can someone help me with this?
Autoshrink is going to fragment every single one of your indexes on a regular basis, that's probably why you need...
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 25, 2011 at 3:28 am
EdVassie (5/25/2011)
didn't want the OP to think RowVersion is a DateTime
Due to a stange decision in the history of SQL Server, the data type known as DateTime does not hold...
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 25, 2011 at 2:44 am
No.
Unless it's causing poor performance due to excessive IOs, in which case you'd be looking at optimising the IO subsystem. Checkpoints are part of normal operation. They run on 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 25, 2011 at 2:04 am
If you have AWE enabled or are running 64-bit, you need to set a sensible max memory. Otherwise it's easily possible for SQL to starve the OS of memory.
If 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 25, 2011 at 1:54 am
Perfmon, the checkpoint pages/sec counter (that's probably what Idera's using). There's a traceflag I can't offhand recall that writes checkpoint info to the error log. There's an extended event 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
May 24, 2011 at 11:50 pm
Viewing 15 posts - 25,936 through 25,950 (of 49,552 total)