Viewing 15 posts - 26,056 through 26,070 (of 49,552 total)
Pages/sec are reads from the page (swap) file, not reads from any file on disk. If SQL is reading pages into its data cache, its reading them from the...
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 18, 2011 at 9:00 am
MysteryJimbo (5/18/2011)
What is your current page life expectancy? A minimum of 600 is the generally accepted limit. If you have plenty of memory it could be much higher.
600...
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 18, 2011 at 8:58 am
Grant Fritchey (5/18/2011)
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 18, 2011 at 6:40 am
Don't see why not. Have you tried?
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 18, 2011 at 6:35 am
I was. :hehe:
Also check see if you have any locks owned by spid -2.
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 18, 2011 at 6:34 am
*screams*
When will people stop recommending Emergency mode repair as the default action with a suspect DB. That's about the 4th time I've seen that garbage this week.
Forget shrink database, I...
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 18, 2011 at 6:33 am
SUPER SQL STAR (5/18/2011)
EXEC sp_resetstatus ‘yourDBname’;
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb(‘yourDBname’)
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB...
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 18, 2011 at 6:31 am
ananthtecho (5/17/2011)
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 18, 2011 at 3:31 am
prettsons (5/18/2011)
Check this article it will help you to resolve this error: http://ezinearticles.com/?Assertion-Or-MDF-Corruption-When-You-Import-Data-in-SQL---Server-2000&id=2228557
Advertising disguised as a technical article. Completely irrelevant here. Full of errors.
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 18, 2011 at 3:20 am
Grant Fritchey (5/17/2011)
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 17, 2011 at 7:38 am
sqlbuddy123 (5/17/2011)
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 17, 2011 at 7:25 am
Oh, forgot to ask. Is this a distributed transaction? (some reference to a remote server)?
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 17, 2011 at 7:22 am
ModestyBlaise84 (5/17/2011)
Detach/attach seemed more ‘natural’ to me, but would like to understand why you advised different?
Doesn't change the DB id, doesn't potentially mess up service broker, CDC or any 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 17, 2011 at 2:10 am
srinath.vanama (5/17/2011)
I tried to move the secondary file through ALTER DATABASE MODIFY command, after copying the .ndf file to the destination folder am not able...
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 17, 2011 at 2:09 am
Use Alter database Modify file to change the file name
Take the DB offline
Move the file
Bring the DB back 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
May 16, 2011 at 11:46 pm
Viewing 15 posts - 26,056 through 26,070 (of 49,552 total)