kjgreen1112 (11/29/2013)

---

While restoring database in sql server 2012, i am getting the following error in sql server 2012

"Exclusive access could not be obtained because the database is in use "

No...

DoolinDalton (11/12/2013)

---

Is it normal for this lastwaittype to last for the entire duration of a backup database command? We're seeing the waittime just continue to tick up until the backup...

thunderousity (11/22/2013)

---

I was using the MDW for a while until I realised that the MDW database size had exploded to 200 GB with about 10 Instances.

Ensure you configure the...

Hi I wanted to revive this thread to see if anyone has used XIV? Their experiences with it. IBM is now on the "third release" of their Storage Product...

Thanks Koen for the suggestions, I will experiment with this and try to come up with fix/sample for myself.

Hi Koen, thanks for the insight into SQL, would you happen to have an example of this? (simple one or pseudo code) To be better understand?

Trying to relate this the...

Thanks for pointing that out, I haven't experienced that before- didn't know that's possible. Ill have to practice/read more on query plans. Ill give that a try tommorow.

Another is "Tidal enterprise scheduler" it is compatible with unix/linux also.

It's great product, I can't speak on the others suggested but this one allows for dependencies on jobs regardless,...

shashi_1409 (10/20/2013)

---

I have some TSQL scripts which ran successfully a week before and now suddenly when I open these files in SSMS its asking me to choose encoding, I am...

If you are using the GUI for Profiler Trace (Taking a guess, but I believe you are)

Have you considered scripting from your template out with appropriate options to run a...

sorry please delete, I mis-read question.

Hi Anada,

Does your service account has permission to the network share?

You should be able to navigate to the folder when you are logged into the server and confirm by...

Could it be possible your SQL Server service acct does not have permissions to the folder? (Try checking permissions to verify?)

Wonder what IOMeter would give?

http://www.sqlservercentral.com/blogs/sqlmanofmystery/2011/06/29/understanding-benchmarks/[/url]

Steve Jones - SSC Editor...

I can identify these but honestly BizTalk is like SharePoint with sql server, kind of a black box....