PFAW: Senator Bennet Caved to the Far Right by Returning his Blue Slip on Allison Eid FOR IMMEDIATE RELEASE: September 6, 2017 Contact: Courtney Neale at People For the American Way
View the SQL Server error log by using SQL Server Management Studio or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.
Historic Reporting Server running SQL 2008 R2. I'm trying to tweak the fill factor. I have a job that records the fragmentation when the jobs runs in the early hours. For every table that had high fragmentation I have reduced the fill factor from the 100% default for specific indexes which has worked well.ut my largest 3 tables are partitioned. Unfortunately in SQL 2008 R2 you cannot amend the fill factor on a specific partition. The fragmentation on the active partition is 99% on several of these indexes when the job runs.