Viewing 15 posts - 17,461 through 17,475 (of 49,552 total)
Yes. Either a index seek + key lookup or a clustered index scan, depending on the % of rows that the query will retrieve
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 23, 2012 at 9:02 am
Why delete it? Does restoring mean that you'll never need to restore that backup again? What happens if the production DB fails and you need to restore full and 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
July 23, 2012 at 8:22 am
SQLSACT (7/23/2012)
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 23, 2012 at 8:20 am
Without seeing messages, no way to say.
http://technet.microsoft.com/en-us/magazine/2009.04.sqlqa.aspx
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 23, 2012 at 8:06 am
The clustered index doesn't do the lookups. It's the target of the lookups. That tells you how many lookups were done to the clustered index.
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 23, 2012 at 8:04 am
dbasql79 (7/23/2012)
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 23, 2012 at 7:45 am
SQLCrazyCertified (7/23/2012)
So, I would say best practice is to stop/start SQL from Configuration Manager.
Nope. You can stop/start SQL from config manager, NET commands, client app (eg SSMS), services, etc with...
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 23, 2012 at 7:44 am
If it's suspect (as opposed to just corrupt), it won't return to normal without running CheckDB with repair allow data loss (the only option valid when the DB is suspect)....
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 23, 2012 at 7:41 am
Starting the service can be done from anywhere. Services, config manager, NET START, etc.
It's changing the service credentials that must only be done from config manager because config manager knows...
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 23, 2012 at 6:30 am
Got backups? It's very likely that restoring from backup will be the best solution here.
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 23, 2012 at 5:53 am
Stamey (7/23/2012)
Is CheckDB cumulative, in that whatever it did before is saved and it continues where it left off?
No.
I ask because it ran for 8 hours the previous day...
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 23, 2012 at 5:51 am
drnorbert (7/22/2012)
Also I always shrink and reorganize files.
Well there's part of the problem. 🙂
Don't shrink. SQL's not like Access where the files have to be regularly shrunk in order for...
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 23, 2012 at 1:07 am
Why would you expect 0 logical reads? Unless the table is completely empty, the query is going to have to read something from the data cache.
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 23, 2012 at 1:04 am
Vikrant S Patil (7/22/2012)
agree, and that is why we had the truncate log on checkpoint option in SQL 2000.
That option is a left over from SQL 7 or earlier, 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
July 22, 2012 at 10:07 am
Vikrant S Patil (7/22/2012)
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 22, 2012 at 9:09 am
Viewing 15 posts - 17,461 through 17,475 (of 49,552 total)