Last Weeks Top 10 “Reading” Links #10
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-10
753 reads
StrateSQL
Reblog: November 30 to December 6
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-07
726 reads
Lost in Translation – Deprecated System Tables – syslockinfo
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-12-06
1,533 reads
Querying Performance Counters in SQL Server
In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query. ...
2012-12-06 (first published: 2012-11-27)
6,772 reads
Blog Redesigned
Since it’s been a while since I made any real changes to the design of this blog, it was time...
2012-12-05
727 reads
Last Weeks Top 10 “Reading” Links #9
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-03
1,010 reads
Lost in Translation – Deprecated System Tables – sysprocesses
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-12-03
2,078 reads
Help Bring #SQLFamily to Fargo, North Dakota
Did you know that a SQL Saturday in Fargo is in the works? If not them, hey… there’s a SQL...
2012-11-30 (first published: 2012-11-26)
1,175 reads
Lost in Translation – Deprecated System Tables – sysprotects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-30
1,810 reads
Reblog: November 23 to November 29
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-11-30
1,475 reads
Blogs
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Locking Hierarchies
Comments posted to this topic are about the item Locking Hierarchies
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;