SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2014

Website Pulse

Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working as a DBA. They’ve now published the article, it can be found at the following link:-


Let me know if you have any comments or feedback – dbafromthecold@gmail.com

Read more

1 comments, 1,165 reads

Posted in The DBA Who Came In From The Cold on 31 July 2014

An error occurred while executing batch. Error message is: Arithmetic Overflow

Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records from the database. The error message the customer received was “An error occurred while executing batch. Error message is: Arithmetic Overflow”.

Experience has taught me that this message is related… Read more

0 comments, 2,219 reads

Posted in Tim Radney - Database Professional on 31 July 2014

Log Shipping - Exclusive access could not be obtained because the database is in use

This story began as they almost always do - with a page at 4am local time...


'Alert: SQL Failed Jobs on InstanceName is Failed'

Job name: LSRestore_InstanceName_DatabaseName
Date & Message: 2014-07-31 05:24:00.0 The job failed. The Job was invoked by User DOMAIN\LOGIN. The last step to run was step…

Read more

2 comments, 8,246 reads

Posted in Nebraska SQL from @DBA_ANDY on 31 July 2014

Please open this page in the Admin panel only

I am taking a slight deviation from the usual type of posts that I share.  This time, I just want to share a quick and easy fix that I ran across due to a broken blog site that lasted for about a day starting on July 28th.

I didn’t even… Read more

0 comments, 1,390 reads

Posted in SQL RNNR on 30 July 2014

This Week in Awesome – Running at PASS, Cookie Jail, SQL Sats, Breakfast

If you’re in Seattle the week of November 2 – say, for example, you’re attending the PASS Summit that week – consider signing up for the #SQLLongRun:  “We’ll do a minimum of 11 miles. Why? Because we can.” There is now a locking, time-release cookie jar. I should….I should probably…

Read more

0 comments, 1,027 reads

Posted in SQL Awesomesauce on 30 July 2014

Building The SQLSaturday Orlando Marketing Plan–Part 27


  • Email with the schedule went out this week, nice bump in registrations – we’re at 229 today
  • Mailed the list twice (bad) because the bulk loaded list is a subset of the attendee list (need to get the criteria for each list)
  • More emphasis on Twitter this week, trying…

Read more

0 comments, 1,055 reads

Posted in SQLAndy on 30 July 2014

PASS SQL Saturday in Parma

This year, 22 November, PASS SQL Saturday will come to Parma, my birth town. I’m proud to be the organizer of that event.
Our community, dotnethell.it, will be there and you can meet some of us

As you can see in the homepage, the venue will be the…

Read more

0 comments, 950 reads

Posted in Alessandro Alpi on 30 July 2014

The clustered index columns are in all of the non clustered indexes.

Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t take my word for it. Let’s take a look!

First things first I’m going to use some AdventureWorks2012 tables to make a test table. Read more

10 comments, 9,406 reads

Posted in SQLStudies on 30 July 2014

Top 10 Recommended Books…

So the title says it all, right?  Well, only really partially.

Recently an article was published listing the top 10 most recommended books for SQL Server.  That’s the part the title doesn’t say.  It is really important to understand that we are talking about the top 10 recommended books for… Read more

0 comments, 1,151 reads

Posted in SQL RNNR on 29 July 2014

How to Edit Read-Only Non-clustered Columnstore Data

As I've discussed in some of my previous posts, 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. This may seem like a huge issue, but in…

Read more

0 comments, 8,086 reads

Posted in Everyday SQL on 29 July 2014

Rename or Change SQL Server Standalone Named Instance

Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance.

Renaming or Changing SQL Server Standalone Named Instance is almost same as SQL Server Standalone Default Instance. You can change a SQL server named SQLServerinstance1 to some other name, such as SQLServerNewinstance1, but… Read more

2 comments, 8,665 reads

Posted in MSSQLFUN on 29 July 2014

Clustered Columnstore Indexes – part 36 (“Maintenance Solutions for Columnstore”)

Continuation from the previous 35 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/

At the 12th Edition of SQLBits around 1 week ago I have had a short but interesting conversation about Columnstore Indexes, its sizes and its importance for rebuild processes with Ola Hallengren.

I have asked Ola to include some specific… Read more

13 comments, 581 reads

Posted in Niko's blog on 29 July 2014

The Growth Of SQLSaturday

A recent Connector showed the following stats for SQLSaturday for the fiscal year ending June 30, 2014 and mentioned 86 events completed:


Impressive numbers to be sure, but are we adding events?   Kendal Van Dyke sent me this projection he did while on the Board of Directors:


That… Read more

0 comments, 7,611 reads

Posted in SQLAndy on 28 July 2014

Building The SQLSaturday Orlando Marketing Plan-Part 26

More notes:

  • In hindsight it’s easy to see we should have worked on the email template first, then the flyers. Email is our #1 way of communicating and it’s important to try to get as much out of it as possible.
  • My original vision was to show the seminars as…

Read more

0 comments, 1,232 reads

Posted in SQLAndy on 28 July 2014

[SQLSTATE 23000] (Error 547) The statement has been terminated. [SQLSTATE 01000] (Error 3621)

SQL Agent job failed with below Error

Executed as user: ArrivalsDepartures. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_DepartureStatusArchive_TechnicianName". The conflict occurred in database "DatabaseName", table "dbo.Users", column 'UserID'. [SQLSTATE 23000] (Error 547)  The statement has been terminated. [SQLSTATE 01000] (Error 3621).  The step failed.

Root Cause

Read more

0 comments, 1,595 reads

Posted in SQL Articles by Nani on 28 July 2014

Last Weeks Top “Reading” Links #94

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 1,003 reads

Posted in StrateSQL on 28 July 2014

What is ANSI_NULLS and why will I be glad when it finally goes away?

Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and said I would discuss it later. Well it’s later.

In the previous post I discussed how NULL is basically “unknown”. And any time you compare something to “unknown” you… Read more

10 comments, 21,990 reads

Posted in SQLStudies on 28 July 2014

Why do we need UPDATE Locks in SQL Server?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I want to talk about a specific question that I almost get every time when I… Read more

10 comments, 11,460 reads

Posted in Klaus Aschenbrenner on 28 July 2014

Book: SQL Server 2014 Development Essentials

I am very happy to announce that my first book “SQL Server 2014 Development Essentials” has now been published by Packt Publishing.

SQL Server 2014 Development Essentials, ISBN: 9781782172550

SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples, which… Read more

1 comments, 1,670 reads

Posted in Basit's SQL Server Tips on 28 July 2014

SSIS Project Deployment under different name

I love SSIS Server, it was one of the greatest addition to the SQL Server Integration Services in 2012 version without any doubt, even though the RTM bits were not production ready.

There is one issue with the SSIS Project Deployment that I have had some issues in the… Read more

0 comments, 594 reads

Posted in Niko's blog on 27 July 2014

Older posts