Viewing 15 posts - 1,336 through 1,350 (of 11,676 total)
teareal_1 (11/25/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 25, 2014 at 5:21 am
Why not simply use EXECUTE WITH RESULT SETS?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 25, 2014 at 1:33 am
Normally in query 1 the execution plan will do an index seek on the clustered index. Since it is unique, it will know to stop when it has found a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 25, 2014 at 12:56 am
Voted.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 25, 2014 at 12:54 am
Nice and easy, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 25, 2014 at 12:50 am
psc032802 (11/24/2014)
run some of the functions. Data profile viewer, for example.
In that case they will most likely need to install BIDS/SSDT. Not 100% sure, it's possible SSIS has to...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 2:54 pm
Stewart "Arturius" Campbell (11/24/2014)
Thomas Abraham (11/24/2014)
Saw Koen's plug for his blog. Can we get him to rewrite...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 12:35 pm
psc032802 (11/24/2014)
If so, then SSIS needs to be installed on the database server and also on...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 12:25 pm
Sean Lange (11/24/2014)
prachisaxena201 (11/24/2014)
SELECT @battery_included = COALESCE(@battery_included + ';', '') + CONVERT(VARCHAR(200),Item)FROM dbo.Split(@battery,';')
help me to understand this query
It looks like you have a delimited string in a variable...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 7:39 am
Karan_W (11/24/2014)
Yes. But I don't see anything written to error output file. I see only date time stamp modified with 1 KB size.
When you go to the execution results and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 4:52 am
OK.
Are all the rows sent to the error output?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 4:31 am
TomThomson (11/24/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 4:03 am
What happens when you try to load the data?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 3:33 am
Steve Jones - SSC Editor (11/20/2014)
It's just a crappy...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 12:42 am
Nice question. I have been bitten by the windowing functions defaults before, so this question was easy 😀
(I even wrote a blog post about it: Beware the defaults! (in windowing...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 12:39 am
Viewing 15 posts - 1,336 through 1,350 (of 11,676 total)