Viewing 15 posts - 3,316 through 3,330 (of 8,731 total)
crookj (2/19/2016)
Revenant (2/19/2016)
ThomasRushton (2/19/2016)
DonlSimpson (2/19/2016)
ThomasRushton (2/19/2016)
Stuart Davies (2/19/2016)
SQLRNNR (2/19/2016)
musselsCOCKLES
Wombles
Tobermory
Harbour
Light
Speed
Force
February 19, 2016 at 10:48 am
Most of your OUTER APPLY derived tables can be rewritten as Cross Tabs to reduce the reads on your snapshot tables. I can't give an exact query as I don't...
February 19, 2016 at 10:01 am
Not to be rude, but you should know this by now:
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
February 18, 2016 at 9:48 am
crookj (2/18/2016)
djj (2/18/2016)
Ray K (2/18/2016)
eccentricDBA (2/17/2016)
bamboozleBambino
BamBam
Dino
Pebbles
February 18, 2016 at 8:23 am
kumar1pr (2/18/2016)
Anyone can point to the reason why first is converted while second one fail?SELECT TRY_CONVERT(DATE,'2016/10/05')
:w00t:
SELECT TRY_CONVERT(DATE,'12/31/2010')
:hehe:
Because the first has a format that isn't misleading, while the second does. 😎
That's...
February 18, 2016 at 8:22 am
John Mitchell-245523 (2/18/2016)
davidawest00 (2/17/2016)
SS will create ALL THE ROWS for a CTE before it processes the main query, whether it will need all those rows or not
Not necessarily. The...
February 18, 2016 at 8:05 am
j-1064772 (2/18/2016)
February 18, 2016 at 7:56 am
djj (2/18/2016)
February 18, 2016 at 7:28 am
Probably something like this:
INSERT INTO #EmailAddrTbl WITH(TABLOCKX)
(AccountID,
LineSeq,
Email)
SELECT AccountID,
MaxLineSeq + ROW_NUMBER() OVER(...
February 17, 2016 at 2:45 pm
Find more information in this article:
http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/
February 17, 2016 at 1:49 pm
mw112009 (2/17/2016)
Can anyone suggest a article/site for me to get started with learning about CUBES
Do you know the concepts of a data warehouse? I'd start with that.
Do you want to...
February 17, 2016 at 1:48 pm
These articles with real life examples are great to help people get rid of cursors and change the mentalities.
I just wanted to make 2 comments:
For sample data, create a table...
February 17, 2016 at 1:38 pm
There's nothing in your query that limits the results to one hour, unless the TagName has something to do with it.
Since you're rounding your Value column, you should use the...
February 17, 2016 at 1:04 pm
Alan.B (2/17/2016)
Luis Cazares (2/17/2016)
You might want to reduce your varchar length. I've never heard of a common use for such large numbers.
haha - I missed the comment about converting to...
February 17, 2016 at 10:50 am
You might want to reduce your varchar length. I've never heard of a common use for such large numbers.
February 17, 2016 at 10:11 am
Viewing 15 posts - 3,316 through 3,330 (of 8,731 total)