Viewing 15 posts - 16 through 30 (of 34 total)
LOL. That's what happens when I'm trying to type to fast. 🙂
Mickey
Jeff Moden (6/3/2015)
Mickey Stuewe (6/2/2015)
I'm looking forward to you reading your article.Mickey
Heh... I've gotta ask... slip or something...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
June 3, 2015 at 9:29 pm
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
June 2, 2015 at 9:25 pm
kbaker91 (6/2/2015)
Simple Question. How are the stats for the different queries acquired?
Hi,
You can turn gather the information with the following two lines of code before running your query.
SET STATISTICS...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
June 2, 2015 at 8:53 pm
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
June 2, 2015 at 8:41 pm
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
June 2, 2015 at 8:26 pm
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)
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
June 2, 2015 at 8:22 pm
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
June 2, 2015 at 8:17 pm
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
March 27, 2015 at 9:59 am
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
January 20, 2014 at 2:41 pm
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
November 5, 2013 at 5:34 pm
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
January 4, 2013 at 12:01 am
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
December 10, 2012 at 11:08 pm
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
December 5, 2012 at 8:30 pm
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
November 15, 2012 at 10:21 am
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...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.
November 2, 2012 at 10:23 am
Viewing 15 posts - 16 through 30 (of 34 total)