Wow!  Mr. R. Barry Young... source of the term "Pseudo Cursors" for me.  How the heck are...

Geez, 1 MILLION?!?!  Will this guy never stop talking?!?

 

Hey Grant, Steve.  Good to hear from you guys.

 

Something else weird, you guys replied to me in like an hour.  But I've been rechecking here every couple of hours, and...

hmmm, i guess the formatting codes have changed a lot ...

 

So question, what's up with the points? I logged in and thought "Holy moley!  Gail's over one million and Jeff's almost there?!?  When are they sleeping?!"

Then I looked at my...

• This reply was modified 5 years, 8 months ago by  RBarryYoung.

hey folks, long time ...

 

Yeah right, Jeff, "Ham and pork...

Anyone else going to SQL Saturday in Philly next week? I don't think I recognized anyone on the speakers list...

If you are looking for a quick and easy magic bullet to significantly reduce your DB space used, there's only really one: use Page Compression on your (biggest/all) tables if...

Erland Sommarskog (3/27/2014)

---

I see that Barry already has attempted to answer your questions, so I will not try to since there are so many of them. 🙂

However, in this article...

JoshDBGuy (3/27/2014)

---

Did you check the history of the job to see how it was invoked? Usually you'll see something like "The job succeeded. The Job was invoked by Schedule...

JoshDBGuy (3/27/2014)

---

The fact that it's sporadic is weird. Are there other jobs that run that could trigger this job to run as well after they are complete using an EXEC...

ErikMN (3/27/2014)

---

...I want to take data from one database to another database that already has data in tables that the data is going into.

For example,

DB1 - Table1 has...

Unfortunately, automated submission...

robin.pryor (3/27/2014)

---

I've been a SQL DBA for decades, but I've never used schemas. I've never had a need to. Now I'm working in a pre-existing server that is using them,...