Viewing 15 posts - 12,526 through 12,540 (of 49,552 total)
There will be messages in the SQL error log saying why the DB was marked suspect. Have a look through the error log, look for messages relating to the database,...
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
July 1, 2013 at 8:19 am
Operating system error 5 is Access Denied. The SQL Server service does not have full rights on that folder.
p.s. sp_attach_db is deprecated and should not be used. Use CREATE DATABASE...
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
July 1, 2013 at 7:52 am
What does the SQL error log say?
What backups do you have?
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
July 1, 2013 at 7:51 am
GilaMonster (12/14/2011)
logicinside22 (12/14/2011)
Is there any other way rather than to DROP?
You can try RESTORE WITH RESTART, but unless the restore time is horrendous, probably unnecessary. The option's intended for absolutely...
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
July 1, 2013 at 7:20 am
The query given above has a number of unnecessary filters in it (as mentioned earlier) that will result in some queries that do table scans not showing up. The given...
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
July 1, 2013 at 7:19 am
Did you read part 2?
You get the code for the procedures by going to the server and scripting the procedure out, you get the performance characteristics by running the procedure...
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
July 1, 2013 at 3:56 am
Depends. What are you trying to do?
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
June 30, 2013 at 11:53 am
Homework?
Exam?
Interview?
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
June 30, 2013 at 11:52 am
Multiple tables is little different from one table.
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
June 30, 2013 at 11:51 am
Hopefully including:
Test all changes on a non-production system
Don't delete database files.
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
June 30, 2013 at 6:26 am
There's nothing there of any use. Are there any logs anywhere with more 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
June 30, 2013 at 3:55 am
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Not the sections on model and tempDB, you've messed that up beyond repair, the section on master, on rebuilding the system databases.
Rebuild them, then restore backups of master and msdb,...
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
June 29, 2013 at 4:37 pm
Change Data Capture, Change Tracking, triggers. All viable options.
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
June 29, 2013 at 11:55 am
http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/
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
June 29, 2013 at 10:47 am
These may help
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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
June 29, 2013 at 10:46 am
Viewing 15 posts - 12,526 through 12,540 (of 49,552 total)