Eric M Russell (4/4/2013)

---

Case in point: Just this morning I was asked to rename a database (AbcCorp -> AbcCorpOld) in the DEV and QA environments and then create...

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...

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...

Yeah, what he said.

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...

ananda.murugesan (4/4/2013)

---

I got it.. according to SQL output 16 Logical CPU...

Pl. correct me if am wrong direction.

For the performance basis for SQL SERVER parallel processing should be equal number...

So 2 physical CPUs x 4 cores each x 2 because of Hyperthreading

= 16 logical CPUs according to SQL Server

It means...

Steve Jones - SSC Editor (4/3/2013)

---

Very interesting discussion.

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...

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...

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...

Yes. Tons. Lookup dimensional modeling. Lookup the Kimball and Inmon methodologies. Lookup the BI Semantic Model for SQL 2012.

patrickmcginnis59 10839 (4/3/2013)

---

Powering...

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...

The issue of whether to use it or not also seems to go a bit beyond security, spilling into application design. If we break this down into two areas where...