SQL PASS Summit Before the Conference Starts
The SQL PASS Summit is getting ready to begin. If you are attending the SQL PASS summit I hope that you have already arrived in Seattle so that you can have some fun tonight at the events before getting started at the conference tomorrow. Things you can look forward to tonight at the PASS summit […]
SSRS runs some crappy queries against the ReportServer Database
While doing some research for my Half Day SQL PASS Session with Stacia Misner (blog | @staciamisner) I discovered that some of the queries which the SSRS engine runs against the ReportServer database are less than perfect total crap. My specific problem is that there are key lookups on the bulk of the queries. Granted […]
SQLFun a great way to meet people and make friends
The SQL PASS summit is quickly approaching, and with the excitement of large conferences comes the worry of what to do during the week. How am I going to meet people, what am I going to do after hours or during the day when there is a session that I don’t want to attend? This […]
New SQL 2008 R2 SP1 trace flag adjusts autostats threshold
I recently learned about a new trace flag which has been introduced in SQL Server 2008 R2 SP1 (and SQL Server “Denali”). This trace flag, number 2371, changes the way that the SQL Server figures out when auto-stats should kick in. Up until now auto-stats was fixed to kick in every time that the column […]