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

Archives: October 2010

SQLBIGeek’s Function Friday – Convert Job Duration to Seconds

 

 

 

Brian K. McDonald

SQLBIGeek

Twitter: @briankmcdonald

 

Welcome to the second post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am hoping that I can provide some of the details about functions that I have either found on the internet or something that I had to create to…

Read more

5 comments, 1,437 reads

Posted in BrianKMcDonald on 29 October 2010

Creating Analysis Services Partitions Using BIDS

As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one thing that can improve performance of your cube is partitioning (splitting up) your measures. In this post, I am going to quickly show you how to switch from a table… Read more

4 comments, 1,646 reads

Posted in BrianKMcDonald on 28 October 2010

SQLBIGeek's Function Friday - Return First Day of Quarter

 

 

Brian K. McDonald

SQLBIGeek

Twitter: @briankmcdonald

 

 

Welcome to the first of my “SQLBIGeek’s Function Friday” blog series. I understand that I am posting it on Sunday for this first post, rather than Friday. However, going forward I am going to post a new function each Friday. Whether it be cleaning…

Read more

1 comments, 729 reads

Posted in BrianKMcDonald on 24 October 2010

SQL Saturday 49 Delivery Mechanisms - Presentation Slide Deck and Files

This past weekend, my wife and I travelled down to Orlando for SQL Saturday 49. I wasn't planning on presenting, but Andy Warren said that he had some mini session slots still available when talking with him at the South Florida SQL Saturday Event. So, I said what the heck...… Read more

1 comments, 169 reads

Posted in BrianKMcDonald on 20 October 2010

When was SQL Server Restarted?

While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the SQL Server Service was restarted. The reason being, the DMV’s get cleared out when SQL Server is restarted! Otherwise, the server I was doing performance testing on could have been… Read more

15 comments, 826 reads

Posted in BrianKMcDonald on 16 October 2010

Return Indexes for a Particular Table using TSQL

I posted a blog recently about returning a listing of all indexes for database, which is good if you want to see how many are in a database. However, you may want to return the indexes for one particular table. Script 1 shown below will do just that!  Just… Read more

1 comments, 436 reads

Posted in BrianKMcDonald on 16 October 2010

Andy Warren’s Word Counter

I typically don’t blog about other people blogs, because quite frankly I don’t like giving summations of the work someone else has provided. I just don’t think it is a very good practice, but every now and then a quick post about something I have seen or found, warrants a… Read more

1 comments, 248 reads

Posted in BrianKMcDonald on 14 October 2010

List Indexes For Database using TSQL

A while ago, I showed you how to find out what indexes were on a table using the GUI. Today, I am going to show you a quick query to determine the indexes for ALL tables in a database. The results will also show you whether it is a… Read more

4 comments, 5,488 reads

Posted in BrianKMcDonald on 14 October 2010

Running Totals for Each Group

A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user recently asked how he could do this within groups of data. So, I thought why not re-address this with another blog. Business Intelligence Design Studio (BIDS) allows us to create… Read more

2 comments, 1,062 reads

Posted in BrianKMcDonald on 11 October 2010

Time Saver – Presentation Preparation

Presenting is a huge fear for many and it is no different for me. I have been presenting at SQL Saturdays, Code Camps, User Groups and internal developer training sessions for the past few years. But for some reason, the initial knots in my stomach cause nearly all of the… Read more

2 comments, 252 reads

Posted in BrianKMcDonald on 10 October 2010

Determine if Directory Exists using xp_cmdshell

Recently, I came across a forum post from a user trying to determine if a directory existed in the file system. The user tried several ways to get a valid response from the system and came up short. I have done something similar in the past (years ago though) and… Read more

5 comments, 3,726 reads

Posted in BrianKMcDonald on 6 October 2010

SQL Saturday 49 Orlando - Delivery Mechanisms using SQL Server Reporting Services (mini)

It's official! I am presenting a mini session for SQL Saturday in Orlando. My topic and some details are below:

 

Delivery Mechanisms using SQL Server Reporting Services

On demand reporting is the most common type of report request using SQL Server Reporting Services, but did you know that there are… Read more

2 comments, 188 reads

Posted in BrianKMcDonald on 5 October 2010

MSDB Job History Duration Conversion

Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this many times in the past, but never blogged about it and when I needed it recently, I couldn’t find my scripts. I could have done a quick search for what… Read more

1 comments, 840 reads

Posted in BrianKMcDonald on 5 October 2010

Converting Dates to Integers

While working on a project recently, I came across a conversion that was trying to convert a date to an integer value. Much like the value one would see in a Date_SK column contained within the DimDate table in a data warehouse. The conversion was actually quite strange and I… Read more

2 comments, 433 reads

Posted in BrianKMcDonald on 5 October 2010

Strange but True - Report Parameter Label Blank

Here is another one of those strange but true things that I come across every so often which I thought I should point out. Its primary focus is when you create parameters in SQL Server Reporting Services. When creating available values for parameters, you can specify a label and a… Read more

3 comments, 853 reads

Posted in BrianKMcDonald on 1 October 2010