When TempDB runs out of space, SQL Server forces the version stores to shrink. So increase space for the tenpDB.

--

SQLBuddy

codenamesql (3/29/2014)

---

Hi guys,

A little background blathering:

I understand that different versions (an even different sp's) may be installed on the same machine but I am concerned that I may be...

lisafox.it (3/28/2014)

---

What error do you get when you try to connect to the Virtual Instance ?

"Cannot connect to SQL_VIRTUAL

Additional Information

Cannot generate SSPI context (Microsoft SQL Server)"

And do you use...

For loading millions of records, it's better to use SSIS. You'll have good performance benefits.

Linked servers are good for less amount of data.

--

SQLBuddy

Check this document ..

http://msdn.microsoft.com/en-us/library/hh918452.aspx

--

SQLBuddy

You need to check for errors before this ..

Could you post those errors before...

Ratheesh.K.Nair (3/28/2014)

---

Hi Experts,

Every midnight 1 row is getting deleted from a particular table. Is there anyway to trace how it happens?

I have checked whether any job is running at that...

Grant Fritchey (3/28/2014)

Unless it's just a huge transaction. In which case, you either have to find a way to reduce the size of the transaction, or you have to have...

tony28 (3/27/2014)

---

Unfortunately, nothing much logged in this log too ..

--

SQLBuddy

Admingod (3/27/2014)

---

Lets consider 2 different tables TABLE A and TABLE B.Now, suppose that there are two different sessions with different activity. Does one of the session will be blocked or...

What error do you get when you try to connect to the Virtual Instance ? And do you use static port for the SQL instance or dynamic ports ?

--

SQLBuddy

Locking is a natural DB phenomenon. You should be worried more about blocking. Provide more details ..

--

SQLBuddy

david.gugg (3/27/2014)

---

I would have to say based on my testing that I disagree with the premise in those links. As a very simple example, I open up a linked...

tony28 (3/27/2014)

---

I found something, but it looks like information about operation.

Log Name: Microsoft-Windows-FailoverClustering/Operational

Source: Microsoft-Windows-FailoverClustering

Date: ...

tony28 (3/27/2014)

---

Ok Now I will do log, after finish I will send..

do you think that is good this setting from your experience ? Auto restart SQL Server if it stops...