(Thomas LaRock) Years ago I left school after getting my graduate degree in Mathematics and got myself a real job, you know the one that had things like a pension and health insurance.
Tag: sql server
SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query
(Pinal Dave) In earlier blog post SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query, we learned how we can use NOWAIT query hint to not wait on any locked query and return error. The Query Hint works on query and table level.
Central Subscriber Model Explained
(Brandon Williams) The majority of SQL Server Replication topologies are based on the Central Publisher model, which is comprised of a single publisher replicating to one or more subscribers.
SQL Server – Attach Database with MDF file only
(Vishal Gajjar) Earlier on my blog I posted about how you can attach a database using T-SQL when no log file is available. You can catch that here. In this post we will see how it can be attached using GUI.
SQL Server CLR and TSQL functions to parse a delimited string
(Greg Robidoux) There are several tips and articles on the internet that discuss how to split a delimited list into multiple rows. This tip shows two approaches to this problem a T-SQL function and a CLR function.
When do statistics update?
(Ted Krueger) The question is often asked: when will SQL Server statistics update if auto update stats is enabled?
SQL Server Data Tools: Why Must Life Be So Hard?
(Thomas LaRock) Every now and then, just when I think that my life is full of obstacles, I think WWHSD (What Would Homer Simpson Do?) which brings me to this:
SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query
(Pinal Dave) Everybody knows about NOLOCK but not everyone knows about NOWAIT. They are different and they have an entire different purpose. In this blog post we will not talk about NOLOCK but we will see how NOWAIT will work.
New and Discontinued MDS Features in SQL Server 2012
(Melissa Coates) Recently I did some research to become more familiar with the new features of Master Data Services in SQL Server 2012, as well as what’s discontinued and deprecated. Below are my notes compiled from reading a variety of sources.
Scatter Line Charts in SSRS
(Jason Thomas) Sometime during the last month, I saw an image of an Archimedean Spiral and was wondering whether I could recreate the same in SSRS. The Archimedean Spiral is actually a scatter line chart (a combination of scatter chart and line chart).