Viewing 15 posts - 841 through 855 (of 2,458 total)
FYI... The FIFO problem was the subject of an SSC competition some years ago. Many interesting techniques to take into consideration: The ‘FIFO Stock Inventory’ SQL Problem
-- Itzik Ben-Gan 2001
April 16, 2016 at 7:59 pm
I was going to post what Jeff posted. :Whistling:
-- Itzik Ben-Gan 2001
April 16, 2016 at 7:49 pm
Luis Cazares (4/15/2016)
Alan.B (4/15/2016)
nagkarjun1 (4/15/2016)
I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.
Updating/defrag Stats...
-- Itzik Ben-Gan 2001
April 15, 2016 at 7:55 pm
MadAdmin (4/15/2016)
Hugo Kornelis (4/15/2016)
TheSQLGuru (4/15/2016)
-- Itzik Ben-Gan 2001
April 15, 2016 at 2:03 pm
nagkarjun1 (4/15/2016)
I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.
Updating/defrag Stats and rebuilding indexes...
-- Itzik Ben-Gan 2001
April 15, 2016 at 1:55 pm
Below is how you'd do it if the data is stored as money or varchar...
-- if stored as money data type
DECLARE @x money = '$154,111.85';
SELECT CAST(@x AS decimal(10,2));
GO
-- if...
-- Itzik Ben-Gan 2001
April 13, 2016 at 1:29 pm
Interesting read Wayne. Good work sir!
-- Itzik Ben-Gan 2001
April 12, 2016 at 10:20 am
This:
I believe that these aren't official terms and they shouldn't be treated as such.
-- Itzik Ben-Gan 2001
April 8, 2016 at 1:31 pm
drew.allen (4/7/2016)
Alan.B (4/6/2016)
You could also do this:
REPLACE(value, char(88), '/')
The replacement depends on the collation, and the default collation is case insensitive. Using the CHAR() function, does not change...
-- Itzik Ben-Gan 2001
April 8, 2016 at 9:33 am
"SQL Server 2016 Developer Edition, when released later this year, will also be free. ":w00t::w00t:
-- Itzik Ben-Gan 2001
April 7, 2016 at 8:27 pm
Steve Jones - SSC Editor (4/7/2016)
-- Itzik Ben-Gan 2001
April 7, 2016 at 2:15 pm
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.
-- Itzik Ben-Gan 2001
April 7, 2016 at 12:25 pm
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...
-- Itzik Ben-Gan 2001
April 7, 2016 at 12:20 pm
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
-- Itzik Ben-Gan 2001
April 7, 2016 at 8:08 am
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.
-- Itzik Ben-Gan 2001
April 7, 2016 at 8:03 am
Viewing 15 posts - 841 through 855 (of 2,458 total)