Lots of ways. You could pass it to a CLR DLL via a CLR proc, and have one of the .NET languages shred it for you. You could...

"Dudes and dudettes" - I'm from California

Jack Corbett (12/8/2010)

---

GilaMonster (12/8/2010)

---

Jack Corbett (12/8/2010)

---

Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any...

Start with Wikipedia. Go from there.

What you'd need to do would be find the first ID for each company name, and then update all the records in the subtable to match those.

For example:

;with PrimaryIDs (PrimaryID,...

On the subject of what's in the DLLs, you may not be able to verify it yourself, but you can insist on a level of code-review and sign-off by the...

As always, please ignore the rabid monkey in the corner. He makes a lot of noise, but he can't actually bite anyone through an Internet connection. He does...

begin transaction;

UPDATE CMLEDG SET TRANDATE = '12/01/2010' WHERE BLDGID = '600' AND PERIOD = '201012';

Run that. Check the numbers. Then add Commit if you want to keep it...

The first part that strikes me as a target for optimization is the delete.

DELETE psa

FROM

PortSecAgg AS psa

JOIN

@DelPortList AS dpl

ONpsa.PortfolioID = dpl.PortfolioID

AND psa.AsOfDate = dpl.AsOfDate

LEFT JOIN

PortSecAgg_staging AS psa_s

ONpsa.PortfolioID = psa_s.PortfolioID

AND psa.SecurityID...

Try running SSMS as an admin. Right-click and select "Run as administrator". See if that helps.

It's kind of a big subject.

The security issues come from a couple of factors. First, have you verified the contents of the DLLs that you're loading as assemblies? ...

Do you want files from it to roll over? Will you keep old trace files?

You'll need to set up a startup proc that will re-start it when the SQL...

There do need to be risk-vs-reward analyses done.

The place I worked in the early naughts went out of business because an "innovative" new service line ended up sucking up all...

LadyRuna (12/8/2010)

---

Dear Santa,

I've been a good little girl and having SQL Monitor and a spiffy iPad would really make my year.

🙂

I've left a bottle of 2005 Chateau-Neuf-du-Pape, a clean...

If it's more than one row at a time, you can use an Output Into clause to get all the IDs you just inserted.

Create a temp table, Output Into it,...