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...
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
October 14, 2015 at 6:50 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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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;
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...
September 29, 2015 at 5:54 pm
Viewing 15 posts - 1,216 through 1,230 (of 2,458 total)