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

Guy Glantser

Guy Glantser is the CEO of Madeira SQL Server Services and the leader of the Israeli PASS chapter. His career has been focused on SQL Server for the past 17 years, performing various database roles as either an on-site DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as Tech-Ed, product launches and user groups around the world. He also co-hosts the Israeli SQL Server radio show.

SQL Server Developer Tips that Can Save Your XXX

Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for developers organized by E4D Solutions. I suggested the title “SQL Server Developer Tips that Can Save Your Ass”, but the organizers didn’t like it, so they changed it… Read more

0 comments, 128 reads

Posted in Guy Glantser on 16 December 2014

How to Handle Dynamic Rowsets

Sometimes you have a stored procedure that returns a rowset, and you need to insert the rowset into a temporary table in order to perform additional processing. That’s easy, right? You can simply create a temporary table and then use the INSERT-EXECUTE statement in order to insert the rowset into… Read more

1 comments, 196 reads

Posted in Guy Glantser on 4 December 2014

Parameterization Part 6: Simple vs. Forced Parameterization

This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan caching works in SQL Server, what parameter sniffing is, when it’s good and when it’s bad, and also some common mistakes related to parameterization and how to avoid them.

In… Read more

0 comments, 133 reads

Posted in Guy Glantser on 27 November 2014

Working with Very Large Tables Like a Pro in SQL Server 2014

I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014. The session was also presented live on PASStv. I was very excited and honored to speak in front of people of the SQL Server community from all over… Read more

2 comments, 299 reads

Posted in Guy Glantser on 8 November 2014

Be Careful! Backups Can Bite You!

Here is a riddle for you…

You are requested to move a database from an old server to a new server. As a professional and experienced DBA, you prepare a checklist of actions to take, you script everything, you document your plan, and, of course, you test it before doing… Read more

9 comments, 6,676 reads

Posted in Guy Glantser on 20 October 2014

Parameterization Part 5: Two Common Mistakes

This is the fifth post in my Parameterization series. In previous posts I wrote about parameter sniffing and when it is good or bad, and also about how to work around the problems associated with parameter sniffing when data is not uniformly distributed. In this post I would like… Read more

7 comments, 7,557 reads

Posted in Guy Glantser on 20 September 2014

DBA in the Cloud: Threat or Opportunity?

Five years ago the term “cloud” was still a buzzword, and there was a lot of uncertainty and misconception around it. I remember many DBAs, including myself, asking themselves what this revolution means for them. People asked themselves how a DBA role will look like in five years, or even… Read more

0 comments, 156 reads

Posted in Guy Glantser on 16 September 2014

Parameterization Part 4: Handling Non-Uniform Data Distribution

This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I mentioned that this method can be a good thing in some cases, but it can also be quite a bad thing in other cases.

One case in which parameter sniffing… Read more

3 comments, 6,193 reads

Posted in Guy Glantser on 8 September 2014

Parameterization Part 3: Parameter Sniffing

This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a very important concept in SQL Server, and it certainly deserves a dedicated post. It’s time to dive into all the juicy details about parameter sniffing…

But first, let’s begin with… Read more

8 comments, 433 reads

Posted in Guy Glantser on 1 September 2014

Parameterization Part 2: Seven Ways to Execute Your Query

This is the second post in my series on parameterization. In the first post I wrote about plan caching and about the phases that each batch goes through before execution. I ended the previous post with a query example that demonstrates the importance of parameterization. For this post I’m going… Read more

13 comments, 7,773 reads

Posted in Guy Glantser on 25 August 2014

Parameterization Part 1: Plan Caching

Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way or another, to parameterization.

On one hand, parameterization is a fundamental subject in the heart of the query processor. It can affect query performance dramatically. On the other hand, it… Read more

8 comments, 7,603 reads

Posted in Guy Glantser on 18 August 2014

My Visit to WPC 2014

Last week I attended WPC. This is an annual event organized by Microsoft for its partners around the world. WPC stands for “Worldwide Partner Conference”, and this is exactly what it is. Last week it was held in Washington D.C, and there were 16,000 people in this event from over… Read more

0 comments, 109 reads

Posted in Guy Glantser on 24 July 2014

My Visit to Redmond

Last week, I had the pleasure of attending the EBC in Redmond. If you don’t know what EBC is, that’s OK. I didn’t know either until Microsoft invited me there a couple of months ago. EBC stands for “Executive Briefing Center”. It’s a building in Redmond designated to host customer… Read more

0 comments, 86 reads

Posted in Guy Glantser on 23 July 2014

Track Incomplete Statements

What about when statements are sitting in your server, uncompleted and not moving, just hogging resources? Use this script for Extended Events to hunt them down.

The post Track Incomplete Statements appeared first on .

Read more

10 comments, 73 reads

Posted in Guy Glantser on 16 July 2014

Space Used by Database Files

Retrieve data about size and space used for all the files in the current database with this script.
 
Some tips on database file size management:

  • Make sure there is enough unallocated space for future growth.
  • If the value of “UnallocatedSpace_Percent” is low, consider allocating more space in the next…

Read more

0 comments, 80 reads

Posted in Guy Glantser on 24 June 2014

What I Love About SQL Server

Well, there are many things I love about SQL Server. Otherwise, I wouldn’t spend my whole career around it, would I? I can talk about the powerful and easy-to-use client tools, or about the excellent high availability and disaster recovery features (aka “AlwaysOn”), or about the powerful ETL platform known… Read more

0 comments, 55 reads

Posted in Guy Glantser on 16 June 2014

Last Backup Times per Database and Backup Type

This script displays the last date and time of each backup type for each database.

It’s useful when you need to know quickly when a database had its last backup.

The post Last Backup Times per Database and Backup Type appeared first on .

Read more

0 comments, 47 reads

Posted in Guy Glantser on 26 February 2014

How to Load Data from Excel in SSIS – 32-bit vs. 64-bit

Let's say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let's assume your dev box is Windows 7 64-bit with SQL Server 2012, and the Excel version is above 2007 (meaning you're using an "xlsx"… Read more

1 comments, 214 reads

Posted in Guy Glantser on 25 February 2014

How to Load Data from Excel in SSIS – 32-bit vs. 64-bit

Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let’s assume your dev box is Windows 7 64-bit with SQL Server 2012, and the Excel version is above 2007 (meaning you’re using an “xlsx”… Read more

2 comments, 51 reads

Posted in Guy Glantser on 25 February 2014

SSIS Appetizer

Madeira’s excellent course on SQL Server Integration Services starts in March, but you can get a head start here!  Take a tour through a few articles, specially chosen by us to get you going, from setting up SSIS to creating your very first work there.  Why not check out our… Read more

0 comments, 44 reads

Posted in Guy Glantser on 9 February 2014

Older posts