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:
WMI Provider Error: Access is denied. [0x80070005] from SQL Server Computer Manager
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]”
What is allocation bottleneck?
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.
Error: 5123, Severity: 16, State: 1 when moving TempDB
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
Don’t Touch that Shrink Button!
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.
The first pillar – A Coherent Design
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
The Lesser Known Features of SQL Server Management Studio (Part 1)
Aaron Alton shows us some handy features in SQL Server Management Studio
Do your servers take for ever to reboot?
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
*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
