Viewing 15 posts - 23,971 through 23,985 (of 49,552 total)
Same thing, backup once after it becomes static, checkDB still necessary.
If it's static, make it read-only.
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 23, 2011 at 1:29 pm
Adding a login to the db_owner role does not make it the owner of the database. A database has a single owner, shown by the query you ran. There 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
August 23, 2011 at 12:50 pm
Sure it is.
Corruption is typically an IO subsystem problem. A misbehaving IO subsystem isn't going to check and see if the DB is flagged as read-only before mangling 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
August 23, 2011 at 12:47 pm
Backups and integrity checks, not index rebuilds or stats updates.
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 23, 2011 at 12:32 pm
Maple07-598122 (8/23/2011)
Using count(*) makes no difference.
No, it won't. It just makes it clearer what you're doing (counting all rows, not counting non-null values) and prevents things breaking if a future...
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 23, 2011 at 12:13 pm
Try changing the query to Count(*) and adding an index on Tl_ProgramDetail (FunddateID)
That's about the only thing that's going to help there. It'll still be a scan, but a scan...
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 23, 2011 at 11:52 am
shew (8/23/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
August 23, 2011 at 11:47 am
GilaMonster (8/23/2011)
If you want additional help with that particular query, post it along with table structure, index structure and exec plans and we'll take a look.
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 23, 2011 at 11:42 am
There are no questions on the MS site. There are lists of topics covered.
Steve is saying that you should be able to answer questions on any of the topics 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
August 23, 2011 at 11:39 am
Common courtesy suggests that you would show your solution.
I haven't given you an answer because your create table threw errors and the query you gave also threw errors (columns 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
August 23, 2011 at 10:58 am
DBCC UPDATEUSAGE
There are bugs in the space-tracking algorithms on SQL 2000. UpdateUsage will fix the incorrect space metadata. You may want to schedule it to run often, though 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 23, 2011 at 10:39 am
Drop the indexes and stats that you created. DTA is not always right, far from it. Recommendations should be tested and only those that actually make a difference implemented.
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 23, 2011 at 10:38 am
Ninja's_RGR'us (8/23/2011)
Especially at PASS :-D.
Yeah, that's just authors and consultants everywhere (especially among the speakers). No one doing real work at all.
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 23, 2011 at 9:18 am
shew (8/23/2011)
Presumably, most posters would have already tried Google and Books Online (as I have) prior to posting on this site.
I wish.
When you get questions like 'What does <statement 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
August 23, 2011 at 9:14 am
It may not be the table, could be the allocation structures, could be the system catalog.
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 23, 2011 at 9:04 am
Viewing 15 posts - 23,971 through 23,985 (of 49,552 total)