Viewing 15 posts - 1,336 through 1,350 (of 11,678 total)
teareal_1 (11/25/2014)
November 25, 2014 at 5:21 am
Why not simply use EXECUTE WITH RESULT SETS?
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...
November 25, 2014 at 12:56 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...
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...
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...
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...
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...
November 24, 2014 at 4:52 am
OK.
Are all the rows sent to the error output?
November 24, 2014 at 4:31 am
TomThomson (11/24/2014)
November 24, 2014 at 4:03 am
What happens when you try to load the data?
November 24, 2014 at 3:33 am
Steve Jones - SSC Editor (11/20/2014)
It's just a crappy...
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...
November 24, 2014 at 12:39 am
Viewing 15 posts - 1,336 through 1,350 (of 11,678 total)