Viewing 15 posts - 1,336 through 1,350 (of 7,168 total)
As long as one is fully aware of the associated security risks and auditability shortcomings, preference is a fair and honest reason to use xp_cmdshell.
April 5, 2013 at 8:52 am
Eric M Russell (4/4/2013)
April 4, 2013 at 6:26 pm
Leaving the development aspects aside per Steve's earlier comment...
Why do folks need xp_cmdshell for admin tasks? I definitely have a sense of people's attachment and willingness to use xp_cmdshell despite...
April 4, 2013 at 9:21 am
See Chapter 3 of this book:
Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias[/url]
Specifically read the sections discussing the 'max degree of parallelism' and 'cost threshold for...
April 4, 2013 at 7:42 am
Thanks for posting back. I was not sure how to easily get across the concern about consistency so I am happy you went through some of the steps and got...
April 4, 2013 at 6:13 am
ananda.murugesan (4/4/2013)
Pl. correct me if am wrong direction.
For the performance basis for SQL SERVER parallel processing should be equal number...
April 4, 2013 at 6:01 am
So 2 physical CPUs x 4 cores each x 2 because of Hyperthreading
= 16 logical CPUs according to SQL Server
April 4, 2013 at 5:18 am
Hyperthread Technology is create two logical processor on actual physical processor, So server has 2 Physical CPU, it means Dual core processor. Hyperthread Ratio is 8, 8*2=16 logical processor.
It means...
April 3, 2013 at 1:11 pm
Steve Jones - SSC Editor (4/3/2013)
Opc.three, you did bring up a few good points, but this isn't one of them.
opc.three (4/3/2013)I understand how xp_cmdshell works but if...
April 3, 2013 at 1:09 pm
I probably would not use replication for this simply because of the potential for problems with consistency at time of cutover.
How about:
1. log ship each database to a new database...
April 3, 2013 at 12:34 pm
Some of the data you want is available through the DMVs, but only for a short time period and it is completely lost after a service restart. To monitor SQL...
April 3, 2013 at 11:56 am
Yes. Tons. Lookup dimensional modeling. Lookup the Kimball and Inmon methodologies. Lookup the BI Semantic Model for SQL 2012.
April 3, 2013 at 11:51 am
patrickmcginnis59 10839 (4/3/2013)
Trust is key but bottom line is xp_cmdshell is a security threat, by definition and in practice. The fewer exposures there are, the better off the environment is.
Powering...
April 3, 2013 at 10:31 am
Just for fun I wanted to see how a CLR might stack up so I ran it through GROUP_CONCAT against 5000 tables with an average length of ~115 characters:
Version using...
April 2, 2013 at 12:11 pm
Viewing 15 posts - 1,336 through 1,350 (of 7,168 total)