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

Archives: February 2013

Presentation Materials “A Function is a Function”

Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of the Performance Impacts of User Defined Functions.

Download: A Function By Any Other Name Is A Function

Other resources:

  • http://msdn.microsoft.com/en-us/library/ms189294.aspx
  • http://www.sqlteam.com/article/intro-to-user-defined-functions-updated
  • http://www.amazon.com/Transact-SQL-User-Defined-Functions/dp/1556220790/ref=sr_1_1?ie=UTF8&s=books&qid=1268026139&sr=8-1

Read more

0 comments, 365 reads

Posted in StrateSQL on 28 February 2013

Webcast “Performance Impacts of User Defined Functions” This Week with Pragmatic Works

Functions might seem to be the answer to all of your desires to consolidate code, and at times they could be.  But if you don’t know enough about them, they may turn out to be the source of all of your problems and opening the door to architecture choke full… Read more

0 comments, 255 reads

Posted in StrateSQL on 25 February 2013

Last Weeks Top 10 “Reading” Links #21

Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet.  Here are the top ten of the items that I linked out last week.  Typically, these are the tweets from things I read in the evenings and then share throughout… Read more

0 comments, 499 reads

Posted in StrateSQL on 25 February 2013

Reblog: February 15 to February 21

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 406 reads

Posted in StrateSQL on 22 February 2013

Five Virtual Labs for the SQL Server 2012 DBA

Wouldn’t it be nice if you had a chance to try out the features of SQL Server?  Maybe give them a run-through before your managers asks you to make recommendations on whether to upgrade and what the value in doing so will be.

For those of us that don’t have… Read more

9 comments, 2,620 reads

Posted in StrateSQL on 21 February 2013

Presentation Materials “What Are You Waiting For?”

Here are the presentation materials for today’s Pragmatic Works Training on the T’s session What Are You Waiting For – Explanation of the Value of Performing Wait Analysis.  The other session that I mention during the presentation is Extended Events: Work Smarter, Not Harder.


Materials: What Are You… Read more

0 comments, 323 reads

Posted in StrateSQL on 21 February 2013

Calculate Bitmasks In PowerShell

Have you ever had to calculate bitmasks on the fly?  I have and still do.  In this post, I’m going to show a simple PowerShell script that can be used to generate bitmask values.  But first, let’s look at a reason that you may have to use bitmasks.

Many of… Read more

2 comments, 492 reads

Posted in StrateSQL on 19 February 2013

Webcast “Value of Performing Wait Analysis” This Week with Pragmatic Works

Ever have your SQL Server slow down for reasons that you can’t explain?  Or did you spend all night tuning a query to perfection only to have it bog down in production?  Want to find out what’s going on?  If so, read on…

This week, I’ll be presenting my session… Read more

0 comments, 313 reads

Posted in StrateSQL on 18 February 2013

Last Weeks Top 20 “Reading” Links #20

Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet.  Here are the top twenty of the items that I linked out last week.  Usually, I do a top 10, but there were just too many good links that I… Read more

0 comments, 303 reads

Posted in StrateSQL on 18 February 2013

Reblog: February 8 to February 14

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 370 reads

Posted in StrateSQL on 15 February 2013

Start Getting Ready for PASS Summit 2013

Seems so early in the year, but it’s already time to start getting ready for this year’s PASS Summit.  There are two things to think about early on with the summit.

First, what are you expecting from the summit?  The summit is built based on community input and PASS Read more

0 comments, 239 reads

Posted in StrateSQL on 14 February 2013

Running SQLIO with Multiple Files

Not exactly groundbreaking information, but were you aware that you can run SQLIO with multiple files?  Until a couple months ago, I hadn’t really paid attention to that little fact.  And maybe I’m the only person that didn’t know, but figured I would share it anyways.

How Multiple Files?

Using… Read more

7 comments, 1,456 reads

Posted in StrateSQL on 13 February 2013

Give Your Valentine Some Discounted Indexing

Looking for that special gift for Valentine’s day and wanting to really change things up?  How about getting your loved one an e-book copy of Expert Performance Indexing for SQL Server 2012?

This week you can get an e-book copy for 40% off if you use the VDAY13 code… Read more

2 comments, 296 reads

Posted in StrateSQL on 13 February 2013

T-SQL Tuesday – Powershell and Perfmon Results – #TSQL2sDay

This month, Wayne Sheffield (Blog | @DBAWayne) is running T-SQL Tuesday on PowerShell.  T-SQL Tuesday is a monthly blogging event where a number of us in the SQL Server community gets together to blog on a central topic. The topic that was chosen for this month was… Read more

0 comments, 299 reads

Posted in StrateSQL on 12 February 2013

February 2013 – Monthly SQL Server Checklist

February is a short month… and if you are following the Monday’s you know that today’s the second Monday of the not the first.  The first Monday is when this update is usually due out.  Unfortunately, I was fairly sick last week and didn’t get to working on this blog… Read more

0 comments, 279 reads

Posted in StrateSQL on 11 February 2013

Last Weeks Top 10 “Reading” Links #19

Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet.  Here are the top ten of the items that I linked out last week.  Typically, these are the tweets from things I read in the evenings and then share throughout… Read more

0 comments, 238 reads

Posted in StrateSQL on 11 February 2013

Reblog: February 1 to February 7

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 398 reads

Posted in StrateSQL on 8 February 2013

Last Weeks Top 10 “Reading” Links #18

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

  1. Disk and File Layout for…

Read more

0 comments, 265 reads

Posted in StrateSQL on 4 February 2013

Ask the Unicorn: Why is it Important to Know Tables in Filegroups?

Earlier this week, I wrote a quick blog post on a throw-away script I had written.  The blog post was DETERMINING FILEGROUP FOR A TABLE.  At the time, I didn’t explain why I needed the information; which prompted the following from one of my readers:

Read your mini-blog in…

Read more

1 comments, 313 reads

Posted in StrateSQL on 1 February 2013

Reblog: January 25 to January 31

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 399 reads

Posted in StrateSQL on 1 February 2013