Who is online?  0 guests and 0 members
Home  »  Blogs  »  KathiKellenberger

Communifire Blogs

Blogs RSS Feed

KathiKellenberger : Most Recent postings

KathiKellenberger

SSIS 2012 Deployment Webinar followup

4/6/2014 by KathiKellenberger  -  Comments: 0  -  Views: [773]

You can find my followup for the webinar here .

Read More

KathiKellenberger

Where did I go?

4/3/2014 by KathiKellenberger  -  Comments: 0  -  Views: [613]

You may be wondering why I haven't posted here for a few weeks. I decided to move over to my own Wordpress blog: http://auntkathisql.com . I will be slowly moving my favorite posts from this blog over to the new one. Please check out my new blogging home!

Read More

KathiKellenberger

T-SQL Window Function Performance webinar follow up

3/14/2014 by KathiKellenberger  -  Comments: 2  -  Views: [1135]

I gave a presentation this week on T-SQL Window Function Performance. You can view the presentation here . You can also download the code and the slides . I had just a couple of questions during this presentation. If you watch the recording and have a question, be sure to post the question as a comment, and I'll be sure to answer it here. Q. Please explain how to determine which columns should be used in the POC index. A. The "P" stands for Partition. If you are using a Partition By clause, then...

Read More

KathiKellenberger

My speaking schedule

3/13/2014 by KathiKellenberger  -  Comments: 2  -  Views: [716]

I love speaking about SQL Server, and I have submitted to several SQL Saturdays and events. If you would like for me to speak at your user group, especially remotely, please leave me a comment here. Here is the my speaking schedule for this year so far. I hope to see you at one of these events! Event Location Date Presentation The Greater Midwest SQL Relay St. Louis February 22, 2014 T-SQL Window Functions T-SQL WIndow Function Performance SQL Saturday #279 Phoenix March 29, 2014 T-SQL Window Fu...

Read More

KathiKellenberger

How Does the Nested Loop Operator Work?

3/13/2014 by KathiKellenberger  -  Comments: 0  -  Views: [762]

Last week I posted a blog that explained when each type of join operator will be used with an INNER JOIN. This week, I would like to describe how one of the join operators, Nested Loop, works. In programming, you can create loops that iterate through a collection or while a condition is true. You can also nest one loop inside another. When this happens, the inner loop will complete one time for every iteration of the outer loop. This is how a nested loop operation works as well. For the nested l...

Read More

KathiKellenberger

Which Join Operator Will My Query Use?

3/7/2014 by KathiKellenberger  -  Comments: 2  -  Views: [630]

There is so much to learn about SQL Server that I am both enthusiastic and overwhelmed when I think about it. Of course, depending on what an individual likes to do, some things will be easier for them. For example, I would trust Itzik Ben Gan with my life if it depended on writing a T-SQL query. But I wouldn’t expect him to be the same level of guru on SSIS or SSAS. (Maybe I am wrong here; he is brilliant and might be an expert on those technologies, too.) For me, the joy of working with ...

Read More

KathiKellenberger

Using a window aggregate function in an aggregate query

2/27/2014 by KathiKellenberger  -  Comments: 0  -  Views: [1268]

A window aggregate function is an easy way to perform an aggregate calculation without changing the query to an aggregate query. This means that you can calculate an aggregate over the entire dataset while keeping the detail in the results. You can also perform calculations on smaller windows, or partitions, of the data. Here is a query that provides an overall total, a total for each customer, and the average sale for each customer. Even though the query is returning sums and an average, the de...

Read More

KathiKellenberger

Have you made it? A question from SQL Saturday #241

2/21/2014 by KathiKellenberger  -  Comments: 1  -  Views: [1076]

I spent last weekend attending the SQL Saturday in Cleveland . The event was held at Hyland Software , a company with sliding boards and pool tables for their staff. It was a very nice venue and the Cleveland SQL Saturday team did a great job. One of the reasons I wanted to attend is the chance to visit the Rock and Roll Hall of Fame . I have visited Cleveland one other time several years ago, but wasn’t able to visit the museum. I went along to the museum with Tim Radney who also arrived ...

Read More

KathiKellenberger

T-SQL Window Functions webinar follow up

2/6/2014 by KathiKellenberger  -  Comments: 0  -  Views: [647]

For those of you who attended my presentation on Feb. 4th, thank you so much! Here is the recording if you missed it or would like to watch it again. Here are the slides and code . I received a number of questions during the session which I will also answer here: Q. Any big changes in 2014 in regards to windowing functions. A. I am sad to say that there are no changes to window functions in 2014 unless Microsoft gives us a last minute surprise. Q. For the percentile rank function, how does the f...

Read More

KathiKellenberger

Avoid Row-by-row Updates with Task Factory Update Batch Transform

1/27/2014 by KathiKellenberger  -  Comments: 0  -  Views: [1320]

SSIS is a fantastic component of SQL Server used for ETL. There are often performance challenges with SSIS packages, and many of the challenges can be solved by moving logic to the database system if possible and avoiding row by row processing. Inside the data flow, you can easily and efficiently insert data into database tables. What is more challenging, however, is doing updates or deletions. The native transform to perform these operations is called the OLE DB Command. This transform performs...

Read More

KathiKellenberger

More Thoughts about ROWS and RANGE

1/24/2014 by KathiKellenberger  -  Comments: 1  -  Views: [855]

I have been speaking and writing a bunch lately on T-SQL window functions. There is always more to learn, it seems. Framing for many of the window functions was introduced with 2012. It is very important to understand how framing works from both a performance and logical perspective. The default frame is RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. If you don’t specify a frame where it is supported this is what you will get. Using this default will give you worse performance than if ...

Read More

KathiKellenberger

T-SQL Tuesday #50: Automation

1/14/2014 by KathiKellenberger  -  Comments: 0  -  Views: [899]

This month’s T-SQL Tuesday is about automation and have methods stayed the same or changed. I haven’t had a chance to automate much recently, but back in the day when I was a database administrator at one company, automation was my favorite part of the job. When would I decide to automate something? Usually, about the third time I performed a task, I would decide to automate it if I had the time. Writing a script to automate a task takes time. Generally more time is taken to write an...

Read More

KathiKellenberger

What's in a Name?

12/31/2013 by KathiKellenberger  -  Comments: 1  -  Views: [625]

As you probably know, the next release of SQL Server will be out sometime in 2014 and will be named SQL Server 2014. This is only two years after the last release, SQL Server 2012. I have been presenting on 2012 topics since before it was released. I generally ask the audience if they are using SQL Server 2012, and very few are actually using it in production. When they learn about the new T-SQL features and AlwaysOn Availability Groups from the presentations, hopefully, that knowledge helps the...

Read More

KathiKellenberger

Setting goals for 2014

12/21/2013 by KathiKellenberger  -  Comments: 1  -  Views: [1041]

It’s that time of the year when you start to take stock of the year and maybe even your life. The New Year is a chance for a new beginning, a time to set or rethink your professional and personal goals. What are the things that you would like to accomplish over the next one to five years? Are you interested in gaining skills in a new area for you, such as virtualization, cloud computing or big data? Will certifications help you get a new job or advance in your current one? Do you want to g...

Read More

KathiKellenberger

Why Working for Pragmatic Works is Perfect for Me

12/14/2013 by KathiKellenberger  -  Comments: 2  -  Views: [1286]

This week was a different kind of week for me. Instead of working for my customer, I taught an SSRS class virtually. The class lasted four days, and I ended up taking a vacation day yesterday. It was nice to get a break from working for a day since I feel like I have been going nonstop since PASS Summit. The only thing I had planned was to visit the law firm where I had been a DBA for eight years and have lunch with some of my former co-workers. In many ways, things are the same there, but some ...

Read More

KathiKellenberger

Framing: ROWS vs. RANGE

12/6/2013 by KathiKellenberger  -  Comments: 0  -  Views: [994]

I have spent a lot of time with Window function this year. I have found that many people haven’t heard about all the features introduced with 2005, or if they have, don’t know the details to get the most out of using them. That led me to creating a session on Window functions and presenting it at many SQL Saturday events, user groups, and PASS Summit 2013 as well as writing many blog posts. I have found that this topic is like an onion, and I keep peeling off layers and learning more...

Read More

KathiKellenberger

Running Total with T-SQL 2012

11/27/2013 by KathiKellenberger  -  Comments: 1  -  Views: [2535]

Writing a T-SQL statement that calculates a running total is really easy with SQL Server 2012. But, if you are not careful, you will see less than stellar performance. Back in 2005, Microsoft began adding window functions to T-SQL. I’ve also seen this called windowed or windowing functions. Either way, this has nothing to do with the Windows operating system. If you have used ROW_NUMBER(), you are using a window function. The window is the set of rows that the function operates on. The win...

Read More

KathiKellenberger

T-SQL 2012 Features

11/27/2013 by KathiKellenberger  -  Comments: 1  -  Views: [1413]

I've written a number of posts recently about the new T-SQL features. I thought it would be helpful for you to have a list with links to each one. You may also be interested in a Training on the T's webinar I did a couple of months ago where I demonstrated several of the features. Using First_Value and Last_value Percentile_Cont and Percentile_Disc Paging Percent_Rank and Cume_Dist Lag and Last Using the Sequence Object Enjoy!

Read More

KathiKellenberger

Presentation Tips from Aunt Kathi

11/19/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1757]

I recently presented on T-SQL window functions at the PASS Summit in Charlotte . Just getting accepted to speak at Summit is a big deal. There are a limited number of slots for community sessions, and potential speakers submit many more abstracts than are possible to accommodate. Selecting the speakers and sessions is a tough job. How do I know that? I was on the Program Committee for five years, two of those as manager. Once I was selected back in May, I made sure I had as many opportunities to...

Read More

KathiKellenberger

T-SQL Tuesday #48: Head in the Cloud

11/12/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1800]

It's T-SQL Tuesday again! This time my colleague Jorge Segarra (@sqlchicken) is the host and the topic is Cloud Atlas . A few years ago I was teaching SSRS for a training company in St. Louis. A gentleman in the class had worked at a local pharmaceutical company for over ten years doing the same job in exactly the same way. The man had been laid off from the company as they made cuts during the downturn in the economy. He was now taking all the SQL Server classes at the training center as part o...

Read More

KathiKellenberger

Fragmentation Presentation Follow Up

11/12/2013 by KathiKellenberger  -  Comments: 0  -  Views: [2642]

Thanks to all of you who attended my presentation on fragmentation. If you would like to view the video, you can find it here . You can also download the code and slides if you would like. As always, there were several questions during the session. If there is something else you would like to ask, please leave a comment. Q: What is the command to get the fragmentation statistics? A: It is a dynamic management function sys.dm_db_index_physical_stats Q: If I delete and rebuild all clustered in a d...

Read More

KathiKellenberger

PASS Summit 2013 Report

10/21/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1691]

I am on a flight to LaGuardia as I write this after spending a week in Charlotte at the SQL PASS Summit . I was only home long enough to attend my brother’s wedding yesterday and sleep about 11 hours before heading to my next customer in New York City. I feel like time has stood still while the Summit captured my entire attention for the past week. I know that things happened in the world like the federal government starting up again and the Cardinals winning the National League Pennant, b...

Read More

KathiKellenberger

Why should you visit the Pragmatic Works booth while in Charlotte?

10/14/2013 by KathiKellenberger  -  Comments: 0  -  Views: [1567]

I am in Charlotte, NC, this week along with a few thousand of my friends for PASS Summit 2013. Many descriptions come to mind like SQLFamily reunion or maybe Nerdvana. If you are lucky enough to be here as well, I encourage you to stop by the Pragmatic Works booth. Even though our booth number is 404, you will still be able to find us! Here are 5 reasons to stop by the Pragmatic Works booth: #5 SWAG: Stop by and pick up some swag: You might get a t-shirt, a book written by Pragmatic Works consul...

Read More

KathiKellenberger

T-SQL Tuesday #47: SWAG

10/8/2013 by KathiKellenberger  -  Comments: 1  -  Views: [1720]

This month’s T-SQL Tuesday topic is SWAG. What is the best T-SQL SWAG you have received? Usually, when I go to SQL Server events, I pick up the things that are useful like luggage tags or something fun for my grandson to play with. Of course, I have several Idera rubber ducks and picked up several foam rockets from Bridgewater that are fun. I even won a $200 gift card at a SQL Saturday a couple of years ago. The best swag I ever received was .Net related. The story behind it means more to ...

Read More

KathiKellenberger

MVP News

10/2/2013 by KathiKellenberger  -  Comments: 1  -  Views: [3101]

I am thrilled to announce that I was selected today to be a SQL Server MVP. The MVP award is given by Microsoft to those who share knowledge and passion with the technical community. For me, that means I write and present constantly. I am joining over 300 people who share my love for SQL Server and about 4000 people worldwide in all of the technologies. You may be wondering how I got to this point and what it takes to be an MVP. Well, as I said, I write a lot. Over the past eight years, I have b...

Read More