BCP should OUTPERFORM this by far.

The problem is that it is NOT as...

For Debugging!!

Note that using nolock does not provides "accurate" values but it could serve as a "guesstimate"

Not Even Backup Files ?

Yes it is an Enterprise Edition issue only.

Are you copying large files in or out of it ?

I have found that to be the culprit on my servers so I...

SA (3/3/2009)

---

Since this is the first cluster, I'm still testing this setup. 8 minutes is definitely excessive.

This is Microsoft's recommendation, but what are other DBA's doing out there?

I haven't enabled...

dr_csharp (3/3/2009)

---

hi friends

i have this :

Execute('Select 1 as [Test],* From myTable')

how can put a character instead 1 in column Test !?

i try this,but has error :

Execute('Select "A" as [Test],*...

SA (3/3/2009)

---

tempdb is re-created each time SQL Server is started. I wouldn't create such large files since SQL Server will take a long time to restart since tempdb needs to...

TRACEY (3/3/2009)

---

If i run the statement below the seeks/scans report.

I know the seeks are better than scans...question is (the counts is based on last time sql shutdown or can you...

The best Application I have found people using virtualization with SQL Server is to reproduce (duplicate) DEV/QA/TEST environments.

Temp tables are scoped at procedure level. your "readuncommited" is what is causing this!

keep in mind that information_schema "hides" the tables...

Take a look at this Jeff Moden article: http://www.sqlservercentral.com/articles/T-SQL/63003/

Unless you are doing special processing you should be able to code the trigger for multi-row changes...

If you are using an stored procedure to insert on the first table you...

1. Do I have to shutdown the distributor and subscribers if I need to restart only my Production?

From what I think, I dont need to....