SQLCrazyCertified (5/24/2012)

---

rodmeans (5/24/2012)

---

Hello,

Can anyone tell me if SQL has a transaction that is open but is in a sleep status, if that SPID is still using CPU resources? I have...

rodmeans (5/24/2012)

---

Hello,

Can anyone tell me if SQL has a transaction that is open but is in a sleep status, if that SPID is still using CPU resources? I have a...

jitendra.padhiyar (5/21/2012)

---

Bulk log recovery model minimize the log space.

As per my knowledge we uses Bulk recovery model when we are using any bulk operation like BCP. Suppose I want...

Lynn Pettis (5/16/2012)

---

SQLCrazyCertified (5/16/2012)

---

erics44 (5/16/2012)

---

Hi

I have always been under the impression that in tables where there are a lot of inserts a clustered index should be avoided and clustered indexes...

erics44 (5/16/2012)

---

Hi

I have always been under the impression that in tables where there are a lot of inserts a clustered index should be avoided and clustered indexes should be used...

anthony.green (5/16/2012)

---

SQLCrazyCertified (5/16/2012)

---

SQLCrazyCertified (5/16/2012)

---

jitendra.padhiyar (5/15/2012)

---

Hello Masters,

During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?

When you install newer version, system databases...

SQLCrazyCertified (5/16/2012)

---

jitendra.padhiyar (5/15/2012)

---

Hello Masters,

During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?

When you install newer version, system databases comes with...

jitendra.padhiyar (5/15/2012)

---

Hello Masters,

During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?

When you install newer version, system databases comes with it....

Hi Jayanath,

This requirement is...

Thanks Gail....Will keep you posted.

TA

Hi Gail,

Sorry, I don't have it.....I was trying to help someone. So, I don't have anymore information.

TA

Gazareth (5/3/2012)

---

I'm trying to work this out as well.

I can understand the problem with a production outage if the DR site goes offline, but if the mirror's at the principle...

gmamata7 (4/25/2012)

---

Hi,

we have a node cluster set up on windows 2008 R2 with sql server 2008 r2 and we have only one sql server instance INS1 on Node1 and Node2...

Gianluca Sartori (4/26/2012)

---

I was wondering how to implement HA for a merge replication subscriber.

Given that:

* mirroring is not an option (by desing)

* clustering still has the storage as a single...

Alan Kwan (4/25/2012)

---

So I checked the install log, it says: SQLSYSADMINACCOUNTS: abc\Adminstrator, SQL_SVC

1) Does that mean the account SQL_SVC was used to install SQL Server?

2) Can this account add...