Viewing 15 posts - 5,791 through 5,805 (of 7,168 total)
steveb. (6/28/2011)
Jayanth_Kurup (6/28/2011)
http://www.lcard.ru/~nail/sybase/perf/18295.htm
The logic seems sound but i doubt if i will...
June 28, 2011 at 2:41 pm
Very true, I knew and should have mentioned that the proc was dropped from the product in 2008.
June 28, 2011 at 2:27 pm
Jeremy-475548 (6/28/2011)
Just curious:Is the except statement just syntactic sugar for "Where Not IN" or is there some additional optimization magic that goes on behind the scenes?
It's quite different from WHERE...
June 28, 2011 at 2:10 pm
One other option...from this forum post:
4 If you dont want to create an EXCEL file in advance and want to export data to it, use
EXEC sp_makewebtask
@outputfile = 'd:\testing.xls',
@query...
June 28, 2011 at 2:06 pm
anjali3386 (6/28/2011)
Have another question...
I want to insert results from sp_depends into a table
SET @sql = 'USE '+@db_name+' EXEC sp_depends '+ @table_name
insert into ##tmp
EXEC (@sql)
But with that I...
June 28, 2011 at 1:38 pm
Ninja's_RGR'us (6/28/2011)
How much faster is it?
Depending on the use case it can be pretty significant, but it depends on the use case and the data of course. The UDA outperformed...
June 28, 2011 at 11:35 am
Here is one other option that seems a bit more intuitive to me but that requires the use of SQLCLR.
This:
with CTE as
(
select name,nameid
from #names
)
SELECT
...
June 28, 2011 at 11:08 am
praveensc2003 (6/28/2011)
I have around 1 lakh data stored in Excel.Is it possible to insert this data in to SQL SERVER using Bulk Insert Task?
To clarify, no, you will not...
June 28, 2011 at 10:51 am
lk-681111 (6/28/2011)
June 28, 2011 at 10:37 am
Thanks for posting back. I bet you could have cut that time in half, at least, if you had used T-SQL (as bitbucket-25253 suggested) instead of SSIS.
June 28, 2011 at 10:21 am
SQLRNNR (6/28/2011)
Here's an article discussing the steps referenced by opc.threehttp://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx
Thanks Jason, I will keep this one to pass along, at least until Jeff publishes his article on how to manage...
June 28, 2011 at 9:41 am
Is xp_CmdShell enabled on the instance? Have you setup the proxy?
If I may ask, what's the goal of granting exec permissions to xp_CmdShell? Maybe there is a cleaner way...
June 28, 2011 at 9:29 am
k.thanigaivel (6/28/2011)
June 28, 2011 at 7:35 am
Nadrek (6/28/2011)
opc.three (6/27/2011)
Like I said, not arguing anything you said. Compliance was not the issue at hand in my scenario.
Setting compliance aside, is even broaching the subject of ancient software...
June 28, 2011 at 7:14 am
k.thanigaivel (6/27/2011)
Dear opc.three,sorry, my result same as your result. I need with out change as '<tst>1>0</tst>'
Sorry, you cannot, the > is a reserved character in XML for use as part...
June 28, 2011 at 6:57 am
Viewing 15 posts - 5,791 through 5,805 (of 7,168 total)