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

Archives: May 2016

What is the max/min size of a decimal data type?

Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and email a report of identity columns that are approaching the limits of their data type. The minimum and maximum values for most numerical data types are documented in Books online,…

Read more

“Tuesday Morning” SQL Break – May 31, 2016

Yesterday it was Monday, which is when I usually aim to post a weekly blog and twitter round-up.  But since I slept-in and went to Valleyfair yesterday, I got an excellent reason not to get this finished.  So instead of a Monday morning post, we’ve got a Tuesday evening.  But… Read more

0 comments, 813 reads

Posted in StrateSQL on 31 May 2016

Running Multiple Threads Quickly

Recently I was looking to generate a quick workload against an instance. I wanted to add to the amount of work my system was doing by executing a number of queries simultaneously. There are a variety of ways to do this, but I just wanted a quick set of queries.… Read more

0 comments, 1,023 reads

Posted in The Voice of the DBA on 31 May 2016

Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS

[2016-May-31] Two different metrics, two different datasets, one may represent a very high value and the other one is very low. What's interesting is that both metrics could be very close related; like Total Product Sales vs. Product Price or Average Monthly Temperature vs. Rainfall over a period of time. 

Read more

3 comments, 1,633 reads

Posted in Data Adventures on 31 May 2016

THE SQL Server 2016 NYC Launch Event Schedule

Presenting the OFFICIAL SQL Server 2016 NYC Launch Event Schedule for Thursday, June 2, 2016, just ONE day after the official SQL Server 2016 RTM June 1, 2016 is here:

8:45-9:00 Simon Facer


Introduction & Kick OFF!

9:00 – 9:45 Robert Davis


New Paradigm for Performance Tuning in… Read more

0 comments, 1,878 reads

Posted in Pearl Knows on 31 May 2016

Precedence Goes to Query Store or Plan Guide?

While presenting at SQLDay in Wroclaw, Poland, on the Query Store, I was asked a pretty simple question, which takes precedence, the Query Store or a Plan Guide?

One of my favorite answers to questions is “I don’t know” because it gives me the opportunity to learn. Let’s figure this… Read more

2 comments, 913 reads

Posted in The Scary DBA on 31 May 2016

Power BI Desktop May 2016 Update Info: Conditional Formatting and Quick Calc

*Update: The Power BI team has finally published a blog post with all the new features and its glorious! Read about all the new enhancements and changes to Power BI Desktop right here.

So it appears that the May 2016 update to Power BI Desktop has dropped without any… Read more

7 comments, 1,251 reads

Posted in SQL with Dustin Ryan on 31 May 2016

I hate saying no

I really do. There is a joke that DBAs say no to everything and there is some truth to that. But if I say No it’s for a reason. A good one. Because I hate disappointing people, and I hate making their work harder. But I promise I have a… Read more

2 comments, 722 reads

Posted in SQLStudies on 31 May 2016

Conditional Formatting and Quick Calcs in Power BI Desktop

There’s a new update out of Power BI Desktop (May 2016), but at the time of writing there’s no official announcement yet.
However, two great new features have been spotted by Chris Webb:

Read more

2 comments, 2,695 reads

Posted in Koen Verbeeck on 31 May 2016

Goodness-of-Fit Testing with SQL Server Part 7.4: The Cramér–von Mises Criterion

By Steve Bolton

…………This last installment of this series of amateur tutorials features a goodness-of-fit metric that is closely related to the Anderson-Darling Test discussed in the last post, with one important caveat: I couldn’t find any published examples to verify my code against. Given that the code… Read more

0 comments, 1,074 reads

Posted in Multidimensional Mayhem on 31 May 2016

Deletes Ignore Check Constraints

I know it sounds a bit odd but DELETE statements really do ignore table constraints. Running the code below in a test database will setup a test to prove this.

CREATE TABLE ProductConstraintTest
  ProductID	INT IDENTITY(1,1),
  ProductCode	VARCHAR(50),
  ProductName	VARCHAR(100),
  Cost		DECIMAL(19,4),
  Price		DECIMAL(19,4)

CREATE FUNCTION chkProductCount()…

Read more

10 comments, 3,474 reads

Posted in The Database Avenger on 30 May 2016

Upcoming Webinars and Events

This coming week is packed full of fun events! On Wednesday, June 1st at 2pm Eastern, I’m participating in a webinar with ActualTech Media called ‘Modern Storage Strategies for SQL Server‘ where we will talk about key concepts from the recent e-book that we released together.

Session… Read more

0 comments, 867 reads

Posted in Technobabble by Klee from @kleegeek on 29 May 2016

Columnstore Indexes – part 83 (“Columnstore Replication in SQL Server 2016”)

Continuation from the previous 82 parts, the whole series can be found at http://www.nikoport.com/columnstore/

A lot of things were changed in SQL Server 2012, which was quite a ground-breaking release if you look at it with a lot of attention – the memory functionality was rewritten, the first appearance of… Read more

0 comments, 971 reads

Posted in Niko's blog on 29 May 2016

Why use a Date Dimension Table in a Data Warehouse

In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling method. In the beginning of Dimensional Modeling, it was called a Time dimension. Since then, the Time dimension has actually been separate from the…

Read more

2 comments, 4,831 reads

Posted in The Smiling DBA on 29 May 2016

Restore a SQL Server Database with Different Methods

Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a common scenario that takes place every now and then lead to the loss of an enormous amount of data. In order to sustain the same, administrative ensure backup plans as… Read more

0 comments, 3,862 reads

Posted in PowerSQL By Prashanth Jayaram on 28 May 2016

Where are SQL Server 2016 Client Tools?

So, you just installed SQL Server 2016 and you’re pretty sure you chose the options to install the client tools and all the components you needed.  You look for SSMS and, what the heck?  it’s not there.  OMG, what have they done?! SSMS is Gone! Seriously, SQL Server Management Studio…

Read more

6 comments, 3,221 reads

Posted in SQL Server BI Blog on 27 May 2016

My 24 Hours of PASS Session Files

I was honored to be selected to join many other great speakers in presenting for the recent 24 Hours of PASS: Evolution of the Data Platform event. My presentation was called New Paradigm for Performance Tuning in SQL Server 2016 and covers two new tools for performance tuning: Query Store…

Read more

Why I'm not attending PASS Summit 2016

I know there has been a lot of drama in the community recently, much of it centered around what people are or are not going to do in conjunction to this year’s SQL PASS Summit. Well this isn’t one of those posts. I promise you that this post is drama…

Read more

Just a week to SQL Saturday in Pensacola

Next week is  SQL Saturday #491 in Pensacola. I’ll be there, along with a number of other great speakers. It’s free SQL Server training, and a great place to vacation. There are a couple pre-conference sessions available as well if you are looking for some training.

Filed under: Blog Tagged:…

Read more

1 comments, 772 reads

Posted in The Voice of the DBA on 26 May 2016

CPU Scheduling Basics – Windows and SQL Server

In this post we’re going to introduce the basics of CPU scheduling.

In a computer system, only one thing can happen at a time. More specifically, only one task can be on a processor at a point in time. This can expand to several tasks if the system has multiple… Read more

0 comments, 1,344 reads

Posted in Anthony Nocentino's Blog on 26 May 2016

Older posts