Here we are with another super fascinating episode of the SQL Friday, The Best SQL Server Links Of The Past Week show
Here is what I found interesting this past week in SQL Land:
Explanation of the following: When you attempt to change the Login Account for the SQL services [SQL Server, SQL Agent, Full Text, Analysis Services] from the SQL Server Computer Manager tool, you may encounter the following error message:
“WMI Provider Error”
“Access is denied. [0x80070005]”
Allocation bottleneck refers to contention in the system pages that store allocation structures. Sunil Agarwal explains what allocation bottleneck is
Installing SQL Server 2005 SP3 or SQL Server 2008 on builds prior to XP SP3 Can lead to Bug Check (0xF4, Blue screen, Critical Process Termination)]3**Due to a bug in Windows XP builds prior to the XP SP2 hot fix or XP SP3 release you may encounter one of the following bugs while attempting to install SQL Server 2008 or SQL Server 2005 SP3 based builds.
Jonathan Kehayias explains how to move tempdb
One very common question that I see on the forums is on index seeks and index scans. A query is resulting in a table/clustered index scan, even though there’s an index on one or more of the columns been searched on. Gail Shaw does a nice explanation
This topic has indeed been done to death. Yet I still often encounter unecessary database autoshrinks, scheduled shrink jobs and at times a seeming lack of knowledge on just what one should be doing as far as their database sizes.
One of the definitions on wiktionary.org for coherence is “a logical arrangements of parts”. In my initial post, I defined “coherent” for database designs in the following manner: cohesive, comprehendible, standards based, names/datatypes all make sense, needs little documentation. Louis Davidson explains Coherent Design
Aaron Alton shows us some handy features in SQL Server Management Studio
Denny Cherry explains what caused this to happen
That is it for this week, I will tag the weekly posts with SQL Friday in case you want to see the whole archive in the future