I doubt the varchar(max) and other long varchar columns are used in where clauses, except rarely on an adhoc basis when somebody was doing research ( which is probably when...

I've decided to exclude 3 specific statistics from our stats maintenance jobs -- these almost always cause the 15-second IO messages and take a long time to update at fullscan....

Just discovered this article and plan to read thoroughly. For several years we used a technique to update stats in parallel with as many as four threads, using an...

Thanks, I knew about full index rebuilds updating stats with fullscan. What I'm trying to figure out is how to target profiler traces that when replayed will be most...

Creating a temporary spt_values view of a temporary table containing the 2,515 rows worked. All of the functionality missing is now working. We still need to do...

Planning to restore master from backup, but that is probably a couple of weeks out. I've noticed that on our sql 2012 instances this view reveals 2,515 records....

Restoring master from backup doesn't look all that daunting after a bit of reading. Now this is a two-node failover cluster so I'd want to make sure that the...

dbo.spt_values doesn't exist, but even if it did can you create a view with the name matching the table it views? The only things not working are right...

Saving to files with timestamp in the name. The request was to keep error log entries ( other than backup/logon messages ) for a year. I could...

Thanks or the feedback. I did see this article, which references Linchi Shea, seems to show that fullscan can be faster than sampling greater than 50% or so due...

I suspect the daytime average write wait on tempdb is very low, but the average is driven very high by doing update statistics on tables with over 150 million records...

The servers have 512GB of memory with sql allowed to use 348GB. The numerous data files are all on a Netapp SAN device. The main user database is...

Thanks !! I did dump a trace file into a trace table, updated just the database name ( since the database IDs were the same on prod and dev )...

I'd like to hear some feedback on how to handle it when you trace your production box, say main database is called Production, then try to replay those trace files...

"The correct approach is to channel automation profits into new enterprises and products. " Sounds good. But could just mean channeling automation profits into more automation and...