Viewing 15 posts - 3,241 through 3,255 (of 7,164 total)
Jeff Moden (9/5/2012)
opc.three (9/5/2012)
That aside, none of what you said speaks to why one would want to incur the additional risk of having xp_cmdshell enabled.
First, done properly, there is no...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 5, 2012 at 9:13 am
I recommend running in FULL recovery and taking lots of backups. If the rollout is multi-phased or prolonged then take a FULL backup at each logical stopping point. You can...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 5, 2012 at 8:32 am
Jeff Moden (9/5/2012)
opc.three (9/4/2012)
Jeff Moden (9/4/2012)
opc.three (9/4/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 5, 2012 at 7:09 am
A great supplement to BOL:
Comparing Table Variables with Temporary Tables By Wayne Sheffield[/url]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 3:21 pm
DataAnalyst011 (9/4/2012)
Does OPENROWSET create another instance to execute the sp against?
Yes, it does. It creates a new session outside the database engine as if it were any other data client...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 3:19 pm
You can output is as XML in grid view so it will appear as a link:
SELECT YourColumnName as [processing-instruction(x)]
FROM YourSchemaName.YourTableName
FOR XML PATH('');
Then click the link to see the entire text.
The...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 3:02 pm
Jeff Moden (9/4/2012)
opc.three (9/4/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 2:38 pm
If you need fresh data then read the file each time in separate Data Flow Tasks, do the transformations you need and send the data downstream. This keeps most of...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 12:19 pm
zsafakhah (9/4/2012)
Dears allhow can i restrics xp_CmdShell accesss to run some command?
for example xp-cmdshell can not run format syntax or delete format?
how is this possible?
Best Regards,
zohreh
You cannot restrict the commands...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 11:44 am
I still don't know which two approaches you're comparing. Maybe if you explained your end-to-end process it will be more clear as to which two approaches you're having doubts about.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 11:31 am
hanrahan_tim (9/4/2012)
Is it possible that when the INTO and fields are added this saves SQL from having to map them out perhaps?
No. There is no difference.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 11:19 am
A simple PowerShell script that opens a connection based on a DSN name would be my first thought to replace it.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 10:47 am
Microsoft is guiding everyone into using the online version. I think I read somewhere that they have or will stop producing the downloadable version at some point.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 10:29 am
Whatever differences you are seeing are anecdotal. There is no difference in the two uses of the syntax in terms of performance. The statements will be optimized and executed the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 10:25 am
This is stating the obvious but your question seems to be a bit unclear, so here it goes.
If you need the same data multiple times then do not reload...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 4, 2012 at 10:20 am
Viewing 15 posts - 3,241 through 3,255 (of 7,164 total)