I don't think that Microsoft can be faulted for insecure data. The database, network, and operating system framework that Microsoft has provided us is solid when it comes to security....

TBIG (6/23/2013)

---

I need to do an INSERT for a subset of records in a table to the same table. What is the best way to determine the primary key of...

tania 56573 (6/5/2013)

---

Hi there,

My company has several instances of the same app. One app/database per client. Now maintenance has become a nightmare. I want to combine all into one. The...

If this is something like an audit log that's accumulates GB of data and is only occasionally queried, then you want to consider inserting these records into an external file,...

djackson 22568 (6/25/2013)

---

I agree that developers need to get better at using proper techniques.

That said, companies are the real root cause of poor software. The opposition to allowing time...

Gary Varga (6/25/2013)

---

Eric M Russell (6/25/2013)

---

By and large, employees are granted more access to data than they really need to perform their job functions. I'm surprised when people talk about...

By and large, employees are granted more access to data than they really need to perform their job functions. I'm surprised when people talk about a database with dozens or...

However why do we need to go to the maintenance plan's log? SQL Server includes the job history. It includes maintenance plans. Why doesn't the job understand there is a...

Cloud services are to SQL Server what web services are (or were) to application development. It's an interesting...

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...