Viewing 15 posts - 15,856 through 15,870 (of 49,552 total)
sqlfriends (10/30/2012)
If I setup a job to reorgnize an index, for example every 6 hours, should each time be shorter than previous one?
Maybe. If you mean reorganise, yes,...
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
October 30, 2012 at 5:03 pm
I strongly recommend you do not go that design path. It's possible, it's not going to be fun and honestly it's not that good of an 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
October 30, 2012 at 4:58 pm
sqlfriends (10/30/2012)
Thanks, when I change the database from bulk-logged mode to simple recovery mode, do I need to do a full backup right after that?
No. If you switch back 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
October 30, 2012 at 4:52 pm
Yes (or removing the index entirely so that SQL will table scan, but that might not be effective)
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
October 30, 2012 at 3:54 pm
Entire books have been written on that subject. One I'd suggest is Grant Frichey's Query performance tuning distilled book.
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
October 30, 2012 at 3:53 pm
You can't take a transaction log backup if the DB is in simple recovery model.
DAtabase getting bigger is just a factor of more data in in.
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
October 30, 2012 at 3:52 pm
George M Parker (10/30/2012)
Is it possible that technique worked in SQL 2000?
No.
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
October 30, 2012 at 2:57 pm
DBCC LOGINFO
If the active portion of the log is at the end of the file (or near the end) you will not be able to shrink because nothing can move...
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
October 30, 2012 at 2:31 pm
Or just download Paul Randal's pre-corrupted databases
http://www.sqlskills.com/blogs/paul/post/Sample-corrupt-databases-to-play-with.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
October 30, 2012 at 2:28 pm
George M Parker (10/30/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
October 30, 2012 at 2:13 pm
The log is a circular file, SQL writes log records until it reaches the end of the file, then cycles round and starts reusing the file from the beginning.
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
October 30, 2012 at 2:10 pm
panwar.jt (10/30/2012)
you all are correct,but I want to know the usage of 251-255 these id used by indid column in sys.sysindexes....
None. The fact that they are not used for indexes...
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
October 30, 2012 at 2:06 pm
Probably not. The fragmented level is not 1000 pages, it's most likely going to be in memory. Maybe, if you're doing huge range scans that require SQL to read ahead...
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
October 30, 2012 at 2:02 pm
WayneS (10/30/2012)
Gail, when do you start your trip, and how has the flight cancellations in the NE USA affected it?
Friday and probably not at all, the flight path goes further...
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
October 30, 2012 at 1:30 pm
TempDB is in simple recovery model, Backup log with truncate_only does nothing to a DB in simple recovery.
When shrinking a log file, you can't shrink past the active portion 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
October 30, 2012 at 1:27 pm
Viewing 15 posts - 15,856 through 15,870 (of 49,552 total)