Viewing 15 posts - 31,681 through 31,695 (of 49,552 total)
The only way you can guaranteed recover a suspect database with no data loss is to restore from a backup. Since you have no backup, you are potentially looking at...
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, 2010 at 2:33 am
Nitya (7/23/2010)
Its noteworthy to know that DMV's are a reflection of historical query data since SQL Server started.
In this case it's since the database was opened. Taking the DB offline,...
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, 2010 at 2:28 am
Bhuvnesh (7/23/2010)
Well in this case , you can opt for SIMPLE recover model and take log backup on 15 min interval.
You cannot take log backups in simple recovery. Log backups...
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, 2010 at 2:28 am
kladibeeto (7/22/2010)
Auto update statistics fire when collumn change 10% of rows on tables larger then app 500 rows.
20% + 500 rows.
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, 2010 at 5:11 pm
Mani-584606 (7/22/2010)
I'm trying to find When were the statistics for a table last updated using the below query and noticed that some Indexes have their statistics last updated date...
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, 2010 at 5:09 pm
Anyone want to add 2 cents here?
http://www.sqlservercentral.com/Forums/Topic956921-145-1.aspx
OP wants to truncate log and shrink DB straight after an index rebuild. Don't have patience for this tonight.
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, 2010 at 4:32 pm
Ram:) (7/22/2010)
I don't know it is the best solution.. But I have one. Please tryUse
If exists ( select 1 from...)
instead form If exists ( select * from...)
Doesn't make a difference....
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, 2010 at 4:12 pm
Try optimising the query inside the EXISTS. If you want a hand with that, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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, 2010 at 4:11 pm
SQL ORACLE (7/22/2010)
The maximum number of versions of the execution plan on a server is two (from SQL Server tutorial).
Not versions. There's one parallel and one non-parallel plan stored...
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, 2010 at 4:01 pm
MegaDBA (7/22/2010)
I think reading is fundamental and you should do more of it, ...I think you just like to hear yourself talk
Cool it. Insults are not called 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 22, 2010 at 3:51 pm
Tom.Thomson (7/22/2010)
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, 2010 at 3:47 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic957435-391-1.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 22, 2010 at 12:21 pm
Paul White NZ (7/22/2010)
GilaMonster (7/22/2010)
Paul White NZ (7/22/2010)
A primary XML index is clearly different from a clustered index...right?
Yes it is, because it can only be defined on an XML 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
July 22, 2010 at 12:14 pm
WayneS (7/22/2010)
Two questions about this list:1. Isn't HEAP a characteristic of the table, meaning that the table has no index?
2. Where is full-text index?
As mentioned to Paul, HEAP is there...
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, 2010 at 12:09 pm
Paul White NZ (7/22/2010)
A primary XML index is clearly different from a clustered index...right?
Yes it is, because it can only be defined on an XML column, because it doesn't affect...
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, 2010 at 12:05 pm
Viewing 15 posts - 31,681 through 31,695 (of 49,552 total)