ekant_alone (5/20/2014)

---

Hello,

I am working on an existing infrastructure and i do not have liberty to change much right now. I am in a situation where app issues update statistics command...

@chris-2,

Thank you very much! That eliminated those Index Spools and made the T-SQL code query more efficient.

I checked the result set on my Dev box and it is...

ChrisM@Work (5/20/2014)

---

Why are you using subqueries in the output list instead of joins? You're reading the ticket table three times and the report table twice, instead of once each as...

Disk replication or SAN to SAN replication, replicates or move the saved data on disk to a different location. The problem with this is, that database engines like MS-SQL keep...

I use RedGate for that, which sends an email.

But in your case, I guess you can copy the DBCC results and save on notepad. Then archive locally on a share....

GilaMonster (4/9/2014)

---

If you want to break things, update the tables, not a view, and if you want to fiddle with stuff that's undocumented, don't complain when it changes from one...

My goal is, be able to recreate the missing non clustered Index with same name and drop the old one. Because the database was restored without a FG that contains...

GilaMonster (4/9/2014)

---

You can't. sys.indexes is not a table, it's a view.

Please, don't try the 'partial...

Lynn Pettis (4/9/2014)

---

First, sys.indexes is not a table but a system view. As the error message indicates it is made up of multiple tables and you can't update multiple...

CavyPrincess (4/26/2012)

---

Anyone heard that vmware snapshots can cause database corruption on SQL Server databases? The VMware is ESX 4 running Windows 2008 R2, and SQL Server 2008 (and R2)

I...

Barkingdog (11/14/2012)

---

I was told that one can not expect reliable results using Task Manager inside a VM (Guest). If that is the case, how do you determine CPU and...

Perry Whittle (3/28/2014)

---

sql-lover (3/28/2014)

---

Perry Whittle (3/28/2014)

---

The default behaviour for an identity column now is to increase the seed after a restart or failover, etc. By doing this

sql-lover (3/27/2014)

---

I fixed...

Gail,

That's actually a good suggestion. I'll do it later during the day.

Perry Whittle (3/28/2014)

---

The default behaviour for an identity column now is to increase the seed after a restart or failover, etc. By doing this

sql-lover (3/27/2014)

---

I fixed it via DBCC...

hboswell (3/27/2014)

---

[Edit: I found the proper procedure and managed to accomplish what I wanted, using the "Restore Files and Filegroups" option, so this comment is now irrelevant]

Here's a related...