Viewing 15 posts - 61 through 75 (of 727 total)
Stewart "Arturius" Campbell (2/14/2014)
twin.devil (2/14/2014)
now who said sql server does not have a heart 😛+1 :laugh:
+10 😛
February 25, 2014 at 11:10 pm
ScottPletcher (2/13/2014)
UPDATE ts
SET
Col1 = CASE...
February 13, 2014 at 10:14 pm
What i'm looking for is any update like this:
UPDATE tbl_source
SET Col1 = CASE WHEN LEN(dbo.fn_ConvertToNumeric(col3)) > 10 AND dbo.fn_ConvertToNumeric(col3) LIKE '111%' THEN SUBSTRING(dbo.fn_ConvertToNumeric(col3), 4, LEN(dbo.fn_ConvertToNumeric(col3)) ELSE dbo.fn_ConvertToNumeric(col3) END
WHERE col2...
February 13, 2014 at 7:56 am
This is simplest one and i tried it by my own. It will not consider the values like
col3 = 11123456789-xyz
In this case it should be 23456789
February 13, 2014 at 7:52 am
Nope there are no cursors used. But I can see the execution plan for the table. And it shows almost 75% of the time taken for Insertion operation.
Attached is the...
February 11, 2014 at 8:03 am
Hany Helmy (2/6/2014)
Carlo Romagnano (2/2/2014)
I also found this doc from MSDN that explains the answerSSAS2005PerfGuide.doc
+1
+1
I have practiced on some basic SSAS and this is new territory for me. So giving...
February 11, 2014 at 2:01 am
Very good question. Something which developers need on day to day basis. 🙂
February 11, 2014 at 1:53 am
I have never checked it but logically seems to go thatw ay only.
February 10, 2014 at 12:16 am
I was totally unaware of this tool. Thanks for this question dude,.
. 🙂
February 10, 2014 at 12:13 am
This is done. There were some more records added at the far end which were taken into consideration based on order by clause.
February 6, 2014 at 1:42 am
Had to search for it but good to know about. 🙂
February 4, 2014 at 10:51 pm
Very good QOTD. The answer here clarifies few thigns about the identity functionality in simplest way. Thanks Lokesh. 🙂
February 3, 2014 at 6:01 am
It was a very good question. The first two were simple but the third one was tricky. 🙂
January 30, 2014 at 6:05 am
Viewing 15 posts - 61 through 75 (of 727 total)