SQL Server

SQL Server Community

SQL Server Blogs

Follow /19 Aug 2014 at 3:00pm / SQL Server

Export a SSMS Query Result Set to CSV

Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools. The simplest way is to select all results and then copy & paste them into whichever other...
18 0 /
Tom LaRock
Follow /19 Aug 2014 at 3:19am / SQL Server

HOW TO: Find Currently Running Long SQL Agent Jobs

A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I’ve been sharing some scripts recently , I decided to verify that this script still works for finding long running jobs in SQL Agent for...
24 0 /
Chris Yates
Follow /18 Aug 2014 at 8:08pm / SQL Server

And Just Like That….Three Years

Time is a constant. Anything and everything requires time it seems, and with that said I received a reminder today that three years have passed since I first started this adventure called blogging. With this blog you will not find perfection, instead...
32 0 /
Stuart Ainsworth
Follow /18 Aug 2014 at 7:05pm / SQL Server

Managing a Technical Team: Building Better

Heard a great podcast the other day from the team at Manager Tools , entitled “THE Development Question”.  I’m sorry to say that I can’t find it on their website, but it did show up in Podcast Addict for me, so hopefully you can pick it up and give...
30 0 /
Ryan Adams
Follow /18 Aug 2014 at 2:51pm / SQL Server

SQLSaturday Precon Cost Structure

Many of you may already know that I am a PASS regional mentor for the South Central region of the United States.  My role is to help user group leaders obtain the tools they need to have successful groups and provide an open platform to discuss challenges...
29 0 /
Kenneth Fisher
Follow /18 Aug 2014 at 1:00pm / SQL Server

Generating a restore script

In order to speed up our backups on a large database our team decided to stripe the backup files. In case you weren’t aware of this particular backup feature it his means that a single backup is written to multiple files which can dramatically speed...
35 0 /
Chris Webb
Follow /18 Aug 2014 at 11:20am / SQL Server

Removing Punctuation From Text In Power Query

In one of my first posts on Power Query (and still my favourite) I found the top 100 words in the complete works of Shakespeare . As always when you’re learning a new tool, though, I look back at what I wrote then and realise there are better ways of...
36 0 /
Follow /18 Aug 2014 at 10:27am / SQL Server

How To Split Non-Empty Partitions When A Clustered Columnstore Index Exists on The Table

Another pithily titled blog post, but this one revisits the feature of SQL Server 2014 that piqued my interest the most: Clustered Columnstore Indexes. I’ve been working with Clustered Columnstore Indexes for the past few months and recently a colleague...
35 0 /
Melissa Coates
Follow /18 Aug 2014 at 2:13am / SQL Server

Using Power Query to Get Data From an Excel File in OneDrive Via URL

In this blog entry I'm going to discuss accessing an Excel file that's stored in OneDrive. What I do *not* want to do is associate the files to my local file path such as c:\users\melissa\onedrive... because another person who downloads the workbook...
41 0 /
Jen Stirrup
Follow /17 Aug 2014 at 9:42pm / SQL Server

Day 6: The Data Analysts Toolkit: Why are Excel and R useful together, and how do we connect them?

Why is analytics interesting? Well, companies are starting to view it as profitable. For example, McKinsey showed analytics was worth 100Bn today, and estimated to be over 320Bn by 2020. When I speak to customers, this is the 'end goal' - they...
48 0 /
Jason Strate
Follow /15 Aug 2014 at 5:00pm / SQL Server

Reblog: August 8 to August 14

Photo credit – Jenn and Tony Bot Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s...
71 0 /
Follow /15 Aug 2014 at 3:47pm / SQL Server

USING SQL & POWERSHELL – Different Methods to List Databases WITH Recovery Models

USING POWERSHELL TO LIST SQLSERVER USER DATABASES WITH RECOVERY MODELS One of op requested to list all the user defined databases where it has been configured with simple recovery model across ‘N’ servers.There are many ways to achieve the requirement...
92 0 /
Tracy McKibben
Follow /15 Aug 2014 at 1:00pm / SQL Server

Friday Followup For August 15, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Do You Need A Log Recovery Tool? Cheating DBCC To...
59 0 /
Stuart Ainsworth
Follow /14 Aug 2014 at 8:23pm / SQL Server

#SQLServer – Where does my index live?

Today, I got asked by one of my DBA’s about a recently deployed database that seemed to have a lot of filegroups with only a few tables.  He wanted to verify that one of the tables was correctly partition-aligned, as well as learn where all of the...
64 0 /
Jason Brimhall
Follow /14 Aug 2014 at 7:29pm / SQL Server

Effects of sp_rename on Stored Procedures

There comes a time when mistakes are made.  Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure.  When a mistake such as that happens, we are given a few choices.  One could either rename the stored...
73 0 /