Viewing 15 posts - 706 through 720 (of 11,676 total)
Easy one. A practice exam question was about the same behaviour. Once you've spent hours finding out why your answer isn't correct, you tend to never forget it again 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 21, 2015 at 5:01 am
Confusing. I use segment elimination to indicate that a segment of rows has been eliminated, not necessarily an entire column.
But I guess that if you eliminate all segments of a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 21, 2015 at 3:45 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 21, 2015 at 3:35 am
Hugo Kornelis (5/15/2015)
SQL-DBA-01 (5/15/2015)
Seems like it's sort of ISNULL function. If it's encountered NULL, the 3rd parameter will replace the entered value. Nice Question.
No, the default parameter of LAG and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 21, 2015 at 3:32 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 21, 2015 at 3:17 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 20, 2015 at 4:37 am
GilaMonster (5/14/2015)
Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 19, 2015 at 3:36 am
Joy Smith San (5/13/2015)
..Hope they will fix the issue and release it again asap.
It should be released by now:
https://www.microsoft.com/en-us/download/details.aspx?id=46694
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 19, 2015 at 3:32 am
preethi.kaliyamoorthy (5/13/2015)
Sorry if I am asking silly doubts. What is IsTransferred here. Is it a property for every table. I am just a beginner. I dont get it.
You asked yourself:
How...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 13, 2015 at 4:28 am
preethi.kaliyamoorthy (5/13/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 13, 2015 at 4:10 am
preethi.kaliyamoorthy (5/13/2015)
Koen,I am sorry. I couldnt understand.
Can you please explain.
UPDATE s
SET IsTransferred = 1
FROM
myTable s
INNER JOIN
myStagingTable t
...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 13, 2015 at 4:00 am
Gah, clicked the wrong one.
More caffeine!
Nice question though.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 13, 2015 at 2:36 am
preethi.kaliyamoorthy (5/13/2015)
Is there any way of doing it without deleting the rows from the source table.
How to mark the rows as transferred instead of deleting it. I should not...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 13, 2015 at 2:27 am
VRT (5/12/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 12, 2015 at 2:48 pm
VRT (5/12/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 12, 2015 at 2:18 pm
Viewing 15 posts - 706 through 720 (of 11,676 total)