Viewing 15 posts - 17,221 through 17,235 (of 49,552 total)
Delete or archive old backups that you don't need. Other than that, add more space to the drive.
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 11, 2012 at 3:17 am
Root cause is that back on SQL 2000 someone messed with the system tables (via allow updates being set to 1). On SQL 2000, CheckDB doesn't run checkcatalog so 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 11, 2012 at 3:15 am
That one's fatal, not repairable in any way and there's no way to get that DB open.
You can try buying a 3rd party data recovery tool and hope that they...
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 11, 2012 at 3:13 am
Autoclose is on for those databases. So whenever no one's using the DB, SQL shuts it down. When you need it again, SQL starts it up and recovers it (going...
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 11, 2012 at 3:10 am
Yes, it went too far. That was doing exactly what we complain about Celko doing - attacking the person not the idea.
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 10, 2012 at 4:09 pm
The varchar and the text do nothing unless populated.
CREATE TABLE [dbo].[TestTable](
[datetimedata] [datetimeoffset] not null default getdate(),
[intdata] [bigint] not null default 0,
[floatdata] numeric(38,0) not null default 0,
[chardata] [char](7500) not null default...
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 10, 2012 at 3:15 pm
sqlnyc (8/10/2012)
I was able to create all of the indexes you suggested except for one on the CheckTaxes table.
Will look at the plan in the morning. Just one thing......
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 10, 2012 at 1:50 pm
Restore the DB and put the log onto a drive with 512 sector size (it's just temporary). Add a new log file on the drive that you want the 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
August 10, 2012 at 1:45 pm
No. That's literally the number of pages that were allocated, middle or end. Tracking mid-index page splits (which are the harmful ones) is near-impossible until SQL 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
August 10, 2012 at 1:43 pm
Restore from 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 10, 2012 at 1:27 pm
Easiest way, get a DB that's > available memory and run a loop querying every table. You want to fill the data cache, not hammer the CPU, so you just...
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 10, 2012 at 1:26 pm
na1774 (8/10/2012)
But Mu DB is alredy in simple recovery
Yes, you said so. Steps are the same no matter what the recovery model is. Identify the cause, resolve the problem, see...
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 10, 2012 at 1:22 pm
I didn't suggest indexing the CTE. Ensure that the tables that take part in that join are indexed.
Temp tables are a tool, use then where they work. Hating temp tables...
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 10, 2012 at 1:16 pm
Identify why the log is not being reused, resolve whatever the particular cause is. See the article I posted earlier titled "Why is my transaction log 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
August 10, 2012 at 12:44 pm
Looks like SQL is seriously over-estimating the rows in several cases... Leading to a far more expensive plan than necessary
Can you try the procedure with the query With PersonalIDs.....
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 10, 2012 at 12:37 pm
Viewing 15 posts - 17,221 through 17,235 (of 49,552 total)