Dharmendra JKT (3/3/2014)

---

Hi,

I have installed SQL Server 2008R2 and 2012 on my testing server.

Microsoft SQL Server 2012 - 11.0.2218.0 (Intel X86)

Jun 12 2012 13:16:18

Copyright (c) Microsoft Corporation

Standard Edition...

If the test DB is R\W, You can't use LShipping\DB Mirroring....

homebrew01 (3/3/2014)

---

Just 1 tempdb file. I recall reading conflicting opinions, so I left it at 1.

To clarify, I do see the other processors working sometimes, but was surprised this time...

sqlbuddy123 (3/2/2014)

---

homebrew01 (3/2/2014)

---

I can only answer a couple of those right now.

MAXDOP is 0, and Cost Threshold for Parallelism is 5. There was no blocking, but I know there was...

homebrew01 (3/2/2014)

---

I can only answer a couple of those right now.

MAXDOP is 0, and Cost Threshold for Parallelism is 5. There was no blocking, but I know there was a...

homebrew01 (3/2/2014)

---

I've got a couple of long running SQL jobs going, and am getting "Lock request timeout period exceeded" and "SQL is busy" messages when using Management Studio. I...

Ness (3/2/2014)

---

I cannot get the oledb providers to work, neither the MS one or the oracle one, from within the import data function. Could you let me know the steps...

Yeah, we have implemented them. Use option 1.

What's the error or issue that you are having ..

--

SQLBuddy

Is your application using Connection Pooling ? Try to check these counters too ..

SQLServer:Memory Manager: Total Server Memory (KB)

SQLServer:Memory Manager: Target Server Memory (KB)

Checkpoint pages per second

Lazy writes / sec

Memory...

Rem70Rem (2/28/2014)

---

Hi,

What is the best way to move a Production database to a test one ever days after processing is done ?

I am thinking about backup/restore as...

More Appropriate answer would be, If Query Cost < CTP , SQL Server won't convert the query into Parallel Query.

--

SQLBuddy

dan-572483 (2/28/2014)

---

I did run dm_indexes_physical_stats on the table and the indexes were all either 0 or 0.45 percent fragmented. So assuming DBCC passes, is it probable that the...

Yes ..

--

SQLBuddy

curious_sqldba (2/28/2014)

---

I have read so many articles, may be i am just missing the point. My understanding is you set your CTP and MAXDOP, if the cost of a given...

elmar.fecker (2/28/2014)

---

with T-SQL Statement. I plan to create a CMD Job, which calls the Programm SQLCMD and then start a T-SQL Skript which starts the SSIS Package. The CMD Skript...