Viewing 15 posts - 31,096 through 31,110 (of 49,552 total)
What's the output of CheckDB when run with the repair_allow_data_loss option?
Do you have a clean backup?
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, 2010 at 6:15 am
MS recommendation is to exclude all SQL database files from virus scans. That's the mdf, ndf, ldf, trn, bak and the error log files at minimum.
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, 2010 at 6:05 am
I would suggest that you try the fuzzy lookup component in SSIS. It's not perfect, but having done a data import from a dirty source recently, I can say from...
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, 2010 at 6:04 am
Not asking for data. Asking for the execution plan please.
Do you really have absolutely no indexes on these tables? If that's the case, that's almost certainly the cause of 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 23, 2010 at 5:59 am
Specify NONCLUSTERED in the definition of the pk. Then the PK will be enforced by a unique nonclustered 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
August 23, 2010 at 4:13 am
Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Is there a supporting index? Are statistics up to 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
August 23, 2010 at 4:12 am
The error means that between the time that the last full backup was run and this log backup, someone has either run BACKUP LOG ... WITH TRUNCATE ONLY or has...
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, 2010 at 4:11 am
Please post new questions in a new thread. Thank 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, 2010 at 2:23 am
Jeff Moden (8/22/2010)
There's one I didn't know. Have a got a Paul or MS link for that?
Got a Paul link (or three).
http://sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-record.aspx
http://sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-page.aspx
Everything in his category 'On disk structures' is...
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, 2010 at 2:12 am
Jeff Moden (8/22/2010)
I'm pretty sure that statistics TIME and IO don't include SQLCLR and I believe they sometimes miss what's happening in UDF's that a query may contain.
Correct on 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 23, 2010 at 2:12 am
shailashree (8/22/2010)
After enabling this option, the application worked fine for two weeks without any deadlock. The problem resumed again after two weeks.
Deadlocks are unlikely to be a result of memory...
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, 2010 at 2:03 am
PaulB-TheOneAndOnly (8/22/2010)
the fun begins with very large databases supporting business critical applications with stringent SLAs.
I'll say. That 1TB mission-critical DB with 0 downtime allowances in business hours could be quite...
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 22, 2010 at 5:06 pm
Move the subqueries from the select clause (where you can only return one column per subquery) to the from clause (where there's no such limit)
If that doesn't help, please post...
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 22, 2010 at 5:00 pm
Ninja's_RGR'us (8/22/2010)
Anyhow, I know you'll still google your socks off tonight so happy googling :-P.
Nah, mainly because I can't think of a search term that'll get me a result without...
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 22, 2010 at 4:58 pm
Sure they are. They're the actual reads done on per table. You won't get exactly the same values as profiler, can't remember clearly why, but differences are only small.
The distinction...
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 22, 2010 at 4:57 pm
Viewing 15 posts - 31,096 through 31,110 (of 49,552 total)