Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.
Sign up to our newsletter now, to keep up to date with all the latest news.
Latest Database Weekly Newsletter Articles
Interviews: Going Beyond the Technical Quiz
In addition to the usual questions challenging the candidate’s knowledge of such things as b-trees, object permissions, database recovery models, and so on, sit the candidate down with the other database developers or DBAs. Arm them with a copy of Management Studio, and a few other tools, then challenge them to discover the flaws in a stored procedure, and improve its performance.
Size Matters: Keep Model Small
I recently discovered an undesirable behavior of SQL Server on a brand new SQL 2008R2SP2 cluster. If the cluster failed over once it was fine. If it was immediately failed back to the original node, it would hang when taking SQL Agent offline.
Transitioning from SMP to MPP, the why and the how
Emma is the Database Administrator at Adventure Works Cycles, a bicycle manufacturing company. At Adventure Works, Emma and her team are using traditional SQL Server SMP as their data warehousing solution. The company has been growing rapidly and with growing competition in the bicycle industry, the business analysts at Adventure Works Cycles would like quicker insight into their data.
How to Edit Read-Only Non-clustered Columnstore Data
Creating a non-clustered Columnstore index will make the index as well as the base table read-only, which means you can’t insert, update, or delete any data until your drop the index. Patrick Keisler describes two methods you can use to edit your read-only data.
What’s New in Oracle 126.96.36.199?
Oracle 188.8.131.52 was recently released with some fanfare. One of the most talked about features is Oracle Database In-Memory, but there’s more to this release than just columnar storage.
Using Triggers to Automatically Add Indexes
Let’s say you’ve got a vendor application that creates tables, loads them, queries them, and drops them all the time. You can’t change the code. The tables involved desperately need an index in order to go faster, and they’re your biggest performance bottleneck. Enter DDL triggers.
Scripting out Contained Database Users
Argenis Fernandez demonstrates that you can, indeed, script out contained database users and recreate them on another database, as either contained users or as good old fashioned logins/server principals.
The 2008 R2 Bug Fix That Breaks RCSI
One of the fixes included in Cumulative Update 11 for SQL Server 2008 R2 Service Pack 2 addresses an "incorrect deadlock" that can occur in a specific scenario (explained later in this article). Unfortunately, the fix introduces a new bug, where SELECT queries under RCSI (read committed snapshot isolation) start taking table-level intent-shared locks.