Forum Replies Created
Viewing 15 posts - 856 through 870 (of 2,462 total)
-
RE: Talking baseball
Cubs first series was a 2 game sweep on the road outscoring the Angels 15-1. We're already 5 games up on the Cards. Feeling good here in Chicago.
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Optimize very frequent running SP
So it's the first query in your proc taking all the time, the part that does the insert into #TempUsers. Quite frankly that plan does not look too terrible and...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Using Code Snippets in SSMS
SQLvis (4/7/2016)
Are there any examples for creating an MDX Snippet?That was my first thought. 😉
You just have templates. I just found this article: http://byobi.com/blog/2013/04/ssms-templates-for-ssas-developers/%5B/url%5D
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Using Code Snippets in SSMS
Great article Luis. I have learned something new today. I never played around with snippets but have a dozen ideas how they can make life easier.
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Replace a capital letter in a string
You could also do this:
REPLACE(value, char(88), '/')"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Performance issues with DENSE_RANK(). Is there a better alternative?
tarr94 (4/6/2016)
Thanks for the responses!Jacob, you're right, I missed something when pasting my sample data. I've corrected it in the original post.
Lynn, I may end up doing exactly that....
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Would You Move For a Job?
Steve Jones - SSC Editor (4/5/2016)
Was in SF last week. It's crazy expensive. I don't even like staying there when I visit. I've gotten to the point I'll stay near..."I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Are the posted questions getting worse?
Greg Edwards-268690 (4/6/2016)
Brandie Tarvin (4/6/2016)
Good morning, peeps.What are we having for breakfast today?
Mine was oatmeal with purple honey (from North Carolina) and assorted fruit. But for some reason I have...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: You are a SQL Server developer who is...
Luis Cazares (4/6/2016)
Ed Wagner (4/6/2016)
Iwas Bornready (4/6/2016)
This is great. I didn't know this simple trick.This is a QOTD that's 3 1/2 years old.
And this functionality is no longer guaranteed to...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Search Optomisation
DesNorton (4/5/2016)
Alan.B (4/5/2016)
Interesting dilemma and great work with the sample data/ddl!Quick question what are the Partnumber column always going to be 6 characters long or less?
Also (and I...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Are the posted questions getting worse?
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Adding totals for previous two days
NP. 😀
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Search Optomisation
Interesting dilemma and great work with the sample data/ddl!
Quick question what are the Partnumber column always going to be 6 characters long or less?
Also (and I expect the...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: Days a Specific Row is Active
swansonm (4/5/2016)
This would work if the termDate is the date of the term of that line/effective rate, but not since the termDate is actually the term date of the line..."I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
RE: About Index - Can we create a nonclustered index on clustered index column
Indexing is a complex topic indeed. I huge part of the game is understanding how your server is using them. I always develop SQL with "Include actual Execution Plan" turned...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
Viewing 15 posts - 856 through 870 (of 2,462 total)