Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Refreshing Excel Power Query & Pivot Tables with SSIS and Task Factory

With SSIS 2014 and earlier there is currently not native way to refresh an Excel workbook which include Power Query queries. Now that functionality is rumored to be included with SQL Server 2016 but if you’re currently running SQL Server 2014 or 2012 you are out of luck. But that’s… Read more

1 comments, 9 reads

Posted in SQL with Dustin Ryan on 15 August 2015

Catch up with T-SQL Tuesday

T-SQL Tuesday is a monthly blog party where we get an invitation the first week of the month to write on a specific topic for the second Tuesday of that month. Adam Machanic came up with the idea and he chooses the hosts.

If you’re interested in hosting, contact him. Read more

0 comments, 1,760 reads

Posted in The Voice of the DBA on 14 August 2015

015 – Brian Davis - WaterOx Consulting

Reading Time: 3 minutes

Brian Davis In WOxPod!, episode # 015 – “Brian Davis” we have...

The post 015 – Brian Davis appeared first on WaterOx Consulting.

Read more

0 comments, 135 reads

Posted in WaterOx SQL on 14 August 2015

SQL Script to find all the triggers defined on a database or on a single table

Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-

SELECT
       tbl.name as [Table Name]
     , trig.name as [Trigger Name]
     , trig.is_disabled 
FROM [sys].[triggers] as trig
INNER JOIN sys.tables as…

Read more

0 comments, 128 reads

Posted in Vivek's SQL Notes on 14 August 2015

We Don’t Trust This Data

“Learning to trust is one of life’s most difficult tasks.” –  Isaac Watts

As data professionals, there are times when our jobs are relatively easy. Back up the databases. Create the dashboard report. Move the data from flat files to the database. Create documentation. There are lots of cogs… Read more

8 comments, 2,110 reads

Posted in Tim Mitchell on 14 August 2015

Hekaton Part 4: Simple Performance comparison - In Memory vs Disk table

Continuing on the Hekaton Series, this post will attempt a very basic performance comparison of In Memory and disk based table.

Table Creation and Data Loading

CREATE TABLE dbo.Disk_tbl
(
[ID] Int identity(1,1) Not null PRIMARY KEY CLUSTERED,
[Data] char(32

Read more

1 comments, 1,513 reads

Posted in SQL and SQL Only on 14 August 2015

PASS Board Update: July 2015

I was actually travelling for most of July and some of that was on holiday with the family, the real family. That’s why I didn’t get a June update posted.

I don’t have anything much exciting to report. We’re finally getting data out of our Chapter database and can report… Read more

4 comments, 142 reads

Posted in The Scary DBA on 13 August 2015

SSMS 2016 CTP 2.2 Setup Failure 0x81f40001

I built a brand new virtual machine running Windows 2012 R2 and SQL Server 2016 CTP 2.2 (the June edition).  The exact version as shown in the error is 13.0.0407.1 but in SSMS it returns 13.0.407.1.  As some of you may know, one of the new things in SQL 2016… Read more

0 comments, 163 reads

Posted in Ryan Adams on 13 August 2015

Stranger Danger… The need for trust with constraints

I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint. Don’t know how it happened. Figured that while I’m at it, I’d go ahead and evaluate every single check constraint in the database to see if I could identify any… Read more

0 comments, 99 reads

Posted in SQL Barbarian on 13 August 2015

Getting Started With Power BI Desktop: Installation

Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to adopt BI technology need not look further. Power BI is easy to learn with its intuitive tools. Gone are the days when building BI solutions always involve massive… Read more

1 comments, 166 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 13 August 2015

Quick Script: Index Sizes

In the world of performance monitoring, there a number of ways to identify problems. Each method is different and usually, neither way is better than another.

Over the years, I’ve started look at metrics around non-clustered indexes to help find problems.   Once while working at a client site, I was… Read more

0 comments, 108 reads

Posted in John Morehouse | Sqlrus.com on 13 August 2015

Reblog: Slow source? Make your data flow buffers smaller!

Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If you have enough memory and you can process more rows at the same time because your buffer is larger, that’s what we want, right? Yes, this is confirmed by the… Read more

0 comments, 105 reads

Posted in Koen Verbeeck on 13 August 2015

Getting and storing a high precision datetime

Earlier today I was working on a project where I was recording some time stamps. In order to get as much precision as possible I decided to go with a datetime2 datatype. Unfortunately when I recorded the time stamp it didn’t quite work out liked I’d hoped.

DECLARE @StartDate datetime2…

Read more

5 comments, 105 reads

Posted in SQLStudies on 13 August 2015

Interview question - Is Clustered index on column with duplicate values possible?

Through this article, we are going to discuss three important interview questions of SQL which are given below:-


 1) Can we create clustered index on a column containing duplicate values?

 2) Can we create a Primary Key on a table on which a clustered index is already defined?

3) If a clustered index…

Read more

0 comments, 172 reads

Posted in Vivek's SQL Notes on 13 August 2015

Hekaton Part 3: Table Creation and Parameters

Part of a Series on "Hekaton". Refer below for previous posts


Having created a "Hekaton" database, Let us create a "In Memory" table
 
CREATE TABLE dbo.HK_tbl
(
 
[ID] Int Not null PRIMARY KEY

Read more

0 comments, 113 reads

Posted in SQL and SQL Only on 13 August 2015

How easy or difficult to write dynamic SQL ? TIP#110

This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach of string concatenation.

This seems very easy but we need to cast the  parameters in VARCHAR and sometimes we stuck in single code.

I am sure this happened with all… Read more

0 comments, 692 reads

Posted in Rajat Jaiswal-337252 on 12 August 2015

Columnstore Indexes – part 62 (“Row Groups Trimming”)

Continuation from the previous 61 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have spoken a lot of times on the aspect of the Columnstore Indexes maintenance during my presentations, and I have even written 2 blogposts Columnstore…

Read more

0 comments, 143 reads

Posted in Niko's blog on 12 August 2015

oPASS & MagicPASS Meeting Tonight

David Pless is presenting:

Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL Database V12. Query Store is designed to help with query performance troubleshooting by making it easier to identify poorly performing statements and finding scenarios where performance regresses. In this… Read more

0 comments, 110 reads

Posted in SQLAndy on 12 August 2015

Here’s the New #Excel 2016 Chart Types!

The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful of new chart types and since I’m a huge fan of awesome data visualizations, I thought I’d take a few moments to play around with them and share my… Read more

0 comments, 13 reads

Posted in SQL with Dustin Ryan on 12 August 2015

Hadoop and Microsoft

In my Introduction to Hadoop I talked about the basics of Hadoop.  In this post, I wanted to cover some of the more common Hadoop technologies and tools and show how they work together, in addition to showing how they work well with Microsoft technologies and tools.  So you don’t… Read more

1 comments, 786 reads

Posted in James Serra's Blog on 12 August 2015

Newer posts

Older posts