Here we are with another superfunkycalifragisexy 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:

Geek City: Too Many Indexes!

Kalen Delaney shows us that each table in SQL Server 2008 can contain a maximum of 999 nonclustered indexes, and 1 clustered index. These include the indexes generated to support any PRIMARY KEY and UNIQUE constraints defined for the t...

Here we are with another super exciting 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:

SQL Server Spatial: EMPTY vs. NULL

Yesterday a friend asked me if it was better to always use a value of GEOMETRYCOLLECTION EMPTY as an alternative to making a geometry/geography column nullable. OGC has its own concept of database NULL, that is [GEOMETRY] EMPTY, whe...

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, A...

Here we are with another amazing episode of the SQL Friday, The Best SQL Server Links Of The Past Week show

Obviously this week is another slow week, here is what I found interesting this past week in SQL Land:

Failure to load Report Manager due to truncated UserAgent string

CSS SQL Server Engineers write about this issue

Here we are with another fascinating episode of the SQL Friday, The Best SQL Server Links Of The Past Week show

Obviously this week is another slow week, here is what I found interesting this past week in SQL Land:

Using SQLIOSim to Diagnose SQL Server Reported Checksum (Error 824/823) Failures

Another good post by the PSS SQL Server Engineers

Here we go with the links for week 3

Interpreting Output from SQLIOSIM

Kevin Kline has a nice post about interpreting output from SQLIOSIM, he also made a follow up post here: More Tidbits on SQLIOSIM

Here we go, the second week of The Best SQL Server Links Of The Past Week series.

It was a slow week this week, didn't see a lot of things

Performance Impact: file fragmentation and SAN -- Part I

Performance Impact: file fragmentation and SAN -- Part II

I decided to do a weekly post with the best SQL Server related links of the week. These are articles that I find useful and think that they also might be beneficial to you the reader.

Here we go

Space Used By Worktables

Kalen Delaney explains how to find the amount of space occupied by a worktable by using DMVs

Defensive d...