Viewing 15 posts - 42,691 through 42,705 (of 49,552 total)
sal527 (12/2/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
December 2, 2008 at 6:30 am
hemanth.damecharla (12/2/2008)
No errors 😀 :w00t:
Excellent!
It may be an idea to run checkDB a little more frequently. Weekly, if you can afford the time, otherwise do some databases one weekend,...
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
December 2, 2008 at 6:12 am
Depends what you mean by a DBA. If you're taking about someone that watches jobs, runs backups and deploys changes only, then maybe their job will disappear. There's a lot...
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
December 2, 2008 at 3:20 am
rajeevtenneti (12/2/2008)
a development dtabase a db of 40Gb with 38GB data takes 37GB on...
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
December 2, 2008 at 3:15 am
Don't use the database migration wizard. That's a really long way.
Take a backup of the SQL 2000 database and restore it on 2005. Once you're restored, rebuild all indexes and...
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
December 2, 2008 at 2:49 am
Can you backup top the local disk and then copy the backup to take.
we are currently using mssql2000 !!
Please post SQL 2000-related questions in the SQL 2000 forums. If 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
December 2, 2008 at 2:46 am
What about the other index, on OUTP_54?
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
December 2, 2008 at 2:42 am
Ok...
I think that this whole mess can be fixed by dropping and recreating two indexes. I'm not going to promise it will, I'm a bit unsure of the meaning 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
December 2, 2008 at 2:16 am
It's a built-in function that returns a resultset of the records currently in the transaction log.
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
December 2, 2008 at 1:45 am
hemanth.damecharla (12/2/2008)
p.s. (unrelated to the corruption)
Why are you shrinking your database on a regular basis? Databases tend to grow as more data gets put in them. It's in their nature.
Not...
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
December 2, 2008 at 1:44 am
The SQL 2005 parser is a lot stricter about what it considers valid SQL. Technically, that syntax isn't valid, but the 2000 parser would accept it, even though it could...
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
December 2, 2008 at 1:39 am
You've got database corruption.
Please run the following and post the results.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a backup? Do you have any idea when...
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
December 2, 2008 at 1:34 am
hemanth.damecharla (12/2/2008)
Sample_Error_String:
Please post the entire output (or save to a text file and attach it)
There may be stuff that you cut out that you think isn't important, but is.
Hold off...
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
December 2, 2008 at 1:27 am
Active/Active implies that there will be a second SQL instance on the second node that has its own databases. Is that what you're planning?
Clustering isn't a performance enhancement. Active/Active doesn't...
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
December 2, 2008 at 1:21 am
See its contents?
Sure.
SELECT * FROM fn_dblog(null, null)
It's not exactly what I'd call human readable though.
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
December 2, 2008 at 1:18 am
Viewing 15 posts - 42,691 through 42,705 (of 49,552 total)