Viewing 15 posts - 38,071 through 38,085 (of 49,552 total)
Grant Fritchey (6/29/2009)
The Rules: They may be stupid, arbitrary and irritating, but god help you if...
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, 2009 at 8:02 am
Chris Harshman (6/29/2009)
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, 2009 at 7:59 am
Could be anything, but Shrinkdatabase shrinks both data and log files. Data file shrink's the bigger problem, but log file shrink can cause issues too.
Bottom line, if you don't want...
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, 2009 at 6:31 am
venu_ksheerasagaram (6/29/2009)
I am having one case here-- I have given a DB in which there is no FULL Backup on the system.
There was a full backup done sometime in 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
June 29, 2009 at 6:30 am
websites2 (6/29/2009)
Am I right in thinking that 5 indexes with 4 columns covering popular queries is better than 10 indexes each on a single column?
In general, yes. The majority 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
June 29, 2009 at 6:23 am
Paul White (6/29/2009)
The usual construction I see has master.sys.columns cross joined to itself. Of course that will not work for anyone with only 9 rows...
I didn't cross join because...
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, 2009 at 6:15 am
Kingsleen Solomon Doss (6/29/2009)
sorry we are shrinking database
There's your answer then. A shrink database will shrink the log.
Why are you shrinking your database though? Databases tend to...
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, 2009 at 6:12 am
If you've never taken a full backup, you cannot take a diff backup. It will fail.
The size of a diff backup depends on the amount of data that's changed since...
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, 2009 at 6:05 am
Kingsleen Solomon Doss (6/29/2009)
Thank you Shaw, We kept autoshrink as false and we do not manually autoshrink anywhere else.
If your log file is decreasing in size, you have a shrink...
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, 2009 at 5:48 am
Not that I've seen, but the first article is always local, the second is sometimes and then the ones below are from other sites. I just check the source and...
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, 2009 at 5:42 am
Add the columns in the index key. Not possible if there's lots or if they're of a type that can't be included.
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, 2009 at 5:41 am
Either you have a maintenance plan option that's doing a shrink or you have autoshrink on or there's a manual shrink job somewhere.
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, 2009 at 5:28 am
You will not be able to see the corrupted pages even with DBCC Page. They're damaged, SQL won't read them. Besides, from looking at the errors, it looks like a...
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, 2009 at 5:21 am
Switch it to bulk-logged. If you switch to simple you'll be breaking the log chain and will need to do a full backup after switching back to full.
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, 2009 at 4:52 am
Disaster recovery? What's that?
I'm almost ready to stop asking if people have backups when they post corruption questions. It's a waste of time.
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, 2009 at 4:51 am
Viewing 15 posts - 38,071 through 38,085 (of 49,552 total)