Viewing 15 posts - 36,931 through 36,945 (of 49,552 total)
You mean like this? (see attachments) If not, describe what the layout should look like please.
What are you trying and what's management studio doing when you try?
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
August 20, 2009 at 8:39 am
Either the files for that database were moved or the permissions on those files were changed.
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
August 20, 2009 at 7:03 am
System database can never be detached.
There are specific ways to restore backups of system databases, and it's different for the different system databases. Consult books online for full details.
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
August 20, 2009 at 5:46 am
Whizkid (8/20/2009)
Is there any way to find what was happened before this db suspect?
From the error messages it shows that when SQL restarted the data and log files for 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
August 20, 2009 at 4:42 am
Paul Randal (8/19/2009)
Why did you CHECKDB model?
I asked him to just to be sure that there wasn't some corruption in model that was coming across when TempDb's recreated. Purely precaution.
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
August 20, 2009 at 1:51 am
GSquared (8/19/2009)
Or video it, and review the video yourself. It's amazing what you'll note when you watch yourself in action. Sounds narcisistic, but it's really useful.
Do that 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
August 19, 2009 at 3:39 pm
Irfan (8/14/2009)
select * from dbo.sysobjects ( not sys.tables)
sysobjects is deprecated in SQL 2005 and will be removed in a future version of the product. Rather use sys.objects, 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
August 19, 2009 at 3:37 pm
You can query sys.databases to see why the log space is not been reused. Check the log_reuse_wait_descr 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
August 19, 2009 at 2:04 pm
Grant Fritchey (8/19/2009)
Did you get any constructive criticism? That's the stuff I live for, when someone actually has useful insights, not just "You did great" or "You stink."
Nothing really useful....
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
August 19, 2009 at 2:04 pm
espanolanthony (8/19/2009)
so deleting indexes that have reads 0 is a good idea?
Not without doing some additional investigation to confirm that the index is not used anywhere. You need data over...
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
August 19, 2009 at 2:01 pm
Whizkid (8/19/2009)
I don't have DB back up but I 've MDF & LDF file and using those files I was re-attached the database.
So do you still have a problem or...
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
August 19, 2009 at 2:00 pm
Roy Ernest (8/19/2009)
GilaMonster (8/19/2009)
*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!Congrats Gail... Party Time.. 🙂
Party time next time I see my Lead (probably next week), I'll make...
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
August 19, 2009 at 10:13 am
Profiler with an SP:Completed event should do the trick. That'll show the total duration, reads, writes and CPU that the procedure did.
The sp:completed event is not one of the default...
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
August 19, 2009 at 10:11 am
Kit G (8/19/2009)
Can you direct me to the reference that explains what you did?
Reference? I'm sure there's one somewhere but I wouldn't know where.
Ok, when there are multiple queries combined...
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
August 19, 2009 at 10:09 am
Jack Corbett (8/19/2009)
GilaMonster (8/19/2009)
*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!Congrats, but of course exactly what I'd have expected for you, barring the one negative comment.;-)
Comment essentially...
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
August 19, 2009 at 10:03 am
Viewing 15 posts - 36,931 through 36,945 (of 49,552 total)