Viewing 15 posts - 1,216 through 1,230 (of 2,458 total)
So, for the first time in a very long time the betting sites have the Cubs as the favorite to win the World Series. We have to beat the Dodgers...
-- Itzik Ben-Gan 2001
October 15, 2015 at 8:24 am
pilab72 (10/14/2015)
Is there any stairway about analytics functions?
Nope. Except for Part 7[/url] of the Stairway to Advanced T-SQL[/url]
I highly recommend Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
-- Itzik Ben-Gan 2001
October 14, 2015 at 6:50 pm
Go Cubs!
-- Itzik Ben-Gan 2001
October 13, 2015 at 6:19 pm
I try to keep up on salary trends for data jobs (BI/DBA/SQL Dev, etc). Though I have not posted my resume anywhere In a few years I still get plenty...
-- Itzik Ben-Gan 2001
October 9, 2015 at 12:16 pm
mw112009 (10/7/2015)
No needFound answer....
DECLARE @id INT
SET @id = 0
UPDATE accounts2
SET @id = id = @id + 1
GO
This technique is what many people refer to as...
-- Itzik Ben-Gan 2001
October 8, 2015 at 9:14 am
Sideout1972 (1/31/2012)
It ran horribly from the command line as well. After taking steps to eliminate memory issues by putting the code that processes an XML doc into its own...
-- Itzik Ben-Gan 2001
October 7, 2015 at 9:56 pm
Is there any way to reduce this code??
Lose that ORDER BY clause; it seems like it's just for display - let display stuff get handled at the application level.
-- Itzik Ben-Gan 2001
October 1, 2015 at 1:20 pm
Are you absolutely, positively getting duplicate records is you don't include that DISTINCT. I bet that query will run relatively faster without it. If you do need that DISTINCT then...
-- Itzik Ben-Gan 2001
October 1, 2015 at 1:12 pm
Great article. I agree that there's a need to learn Hadoop, NoSQL, etc as that's the trend and where businesses are heading. The well rounded data professional who knows multiple...
-- Itzik Ben-Gan 2001
October 1, 2015 at 9:45 am
The reason it is so serious is because they only keep a couple weeks worth of backups which have never been tested. They are all stored on the same SAN...
-- Itzik Ben-Gan 2001
September 29, 2015 at 8:12 pm
What Drew said.
I would add that, based on what you're showing UNION ALL is probably what you want. If you read Itzik Ben-Gan, he often refers to UNION as...
-- Itzik Ben-Gan 2001
September 29, 2015 at 8:05 pm
Wouldn't it be better to have at least separate stored procedure to use in all those different places but only returning columns that they actually need or maybe replace it...
-- Itzik Ben-Gan 2001
September 29, 2015 at 7:54 pm
I run into this all the time. The problem with DR specifically is it's not sexy. Execs love bragging about, "Now we can <fill in the blank> right from my...
-- Itzik Ben-Gan 2001
September 29, 2015 at 7:06 pm
... Or you can use PatternSplitCM (Duh...) also referenced in my signature....
SELECT Item
FROM #Sample S
CROSS APPLY dbo.PatternSplitCM(S.Numbers,'%[0-9]%')
WHERE Matched = 1;
-- Itzik Ben-Gan 2001
September 29, 2015 at 6:04 pm
One way to approach this involves 3 functions: one that removed duplicate characters, one that replaces characters based on a pattern and Jeff Moden's Splitter. There are links to two...
-- Itzik Ben-Gan 2001
September 29, 2015 at 5:54 pm
Viewing 15 posts - 1,216 through 1,230 (of 2,458 total)