LOL. That's what happens when I'm trying to type to fast. 🙂

Mickey

Jeff Moden (6/3/2015)

---

Heh... I've gotta ask... slip or something...

Hi John,

I wish I could sit down with you over a cup of coffee and several hours to discuss all the items you've brought up. There are answers to all...

Hi,

You can turn gather the information with the following two lines of code before running your query.

SET STATISTICS...

Hi Chris,

You found one of the "stored procedures" I didn't convert to "query. I thought I caught them all.

Your comments are all valid. But what I have found...

Hi Adar,

About 2/3rd down the article. There is a chart. The first column shows how long each query ran in milliseconds. Queries 2 and 4 ran faster because they...

Thanks Jeff. There is one thing that I've learned, there is no silver bullet. I'm looking forward to you reading your article.

Mickey

Jeff Moden (6/2/2015)

---

While this is a good example and...

Hi,

Your last paragraph explained what I was trying to say. Reducing I/0 is important, but it's not going to help the overall performance of your entire workload if the...

Hands down, I prefer SSMS. This past month had no choice, but to use SSDT for source control and schema compare through SSDT and I didn't care for it. It...

Wow. Where to begin.

There are two types of "poor writers", and I'm using that term loosely. The first is the lazy people. Who don't take the time to spell...

Which version of SSRS are you using? There is a function that came out in SSRS 2008 R2 called LookupSet. It might do what you need. It's been a while...

The first thing you should consider is, is it possible to remove the code from the function structure. The SQL Optimizer treats Functions as if they will only return one...

What about Hs.FeactionalPart? Is it a float or did you cast it as a float when you cast the other parts? SQL Server doesn't always do implicit conversions the way...

It's a query, within a query. In the example you gave, the inner query would be executed first to get a value that can then be used in the outer...

The non-clustered indexes are re-built so that the key from the clustered index can be added to the end of them. That way the non-clustered indexes can use the clustered...

You are right demofox about the INTO #temp. I didn't have SQL Server with me when I posted last night so I couldn't test my code. I appologize. I'll try...