Deleting rows in chunks is the way to go, but you also need to perform a checkpoint and transaction log backup between each iteration. That will insure that the inactive...

Revenant (6/11/2013)

---

Steve Jones - SSC Editor (6/11/2013)

---

. . . I could see all kinds of quick analysis stuff moving because it's easier or quicker to throw something up in a...

Gary Varga (6/11/2013)

---

chrisn-585491 (6/11/2013)

---

I can see a scenario where organizations turn to cloud based services to host their e-commerce database or quickly spin up some one-off analytical solution requested by...

chrisn-585491 (6/11/2013)

---

It's funny that WinForms is still...

Richie T (6/7/2013)

---

Hi Guys,

Any Ideas what the best way would be to perform this update?

UPDATE

D

SETTrack_ID= P.Track_ID,

Territory_ID= P.Territory_ID,

Major= P.Major

FROMStaging.Track_MappingP

INNER JOINStaging.Track_PlayD

ONP.ISRC= D.ISRC_Code

ANDP.Event_Date= D.Event_Date

Both tables have around 63 million rows and have numerous...

How long before Microsoft has a similar service that might troubleshoot issues with products, perhaps even working with developers to find bugs and workarounds. I'd imagine that this service would...

jcrawf02 (6/10/2013)

---

Grant Fritchey (6/10/2013)

---

After visiting TechEd, I'm more and more convinced, the damn is going to break and we'll see tons of people using Azure, or, Microsoft is going to...

Oh, those of us who just finished our 2012 certifications are looking forward to this.

Failover clusters are a good idea, but don't let your SAN be a single point of failure. Years ago, I worked at a place which actually had invested in a...

L' Eomot Inversé (6/8/2013)

---

mtillman-921105 (6/8/2013)

---

I found that I can buy Chimay's Red Cap beer at my local liquor store! It's terrific, but pricey. The bottle even had a...

Brian Carlson (6/6/2013)

---

The views option would work if we could prevent them from joining views. There might be a way to prevent that but I'm not sure how. I read...

I was about to...

Brian Carlson (6/5/2013)

---

Agreed about the problems with allowing non-technical users access. One of the requirements to get login permissions will be passing a SQL Query exam though. Of course, user's...

You can use REPLACE() function to strip character sequences from a varchar column like so:

select replace( col1, '@DAR', '' );

You can also use the LIKE operator to return (or check)...

From my experience, it's a waste of time to allow non-technical users to run ad-hoc queries against a database. What will typically happen is that they'll run a bunch of...