The answer is clearly wrong. Some of these questions are really questionable.

The

will also return the string. The left function of @b-2...

Will do. I'll put me feedback there.

David Rueter (12/31/2014)

---

<snip>

In fact, I didn't really realize that this article was going to be re-published this month. I have several refinements...

Here's the answer: On the server, running in a job, results were returned but were getting trucated at 512 characters. I needed to add one statement before calling the sproc...

Suggestion: Change the spgetInitSession to create the temp tables and then execute user code. This avoids pasting (potentially changeable) SQLDOM code into user's procedures and neatly resolves the temp table...

I'll put my bug report here, and thanks for the work on this!

First, a not-a-bug query: This works fine on my Workstation, but fails to get the data from URLs...

We're building a service business, and reliability and scalability are requirements, so we'll be deploying the production system to Azure.

Dealing with CLR procedures is a black art. Be sure to document that so you will remember in a year, when one database is moved again!

I run shrink on our Dev server after running lots and lots of queries to reduce the transaction log size (on disk). It's easy to grow a log file...

This phenomenon of specialization has been developing for years. I manage a (very) small programming & development staff of three. We each have our areas of specialization: ...

Because we deal with health Care-related information, we never delete anything. My biggest DB is now about 20GB, growing 100MB per day.

There is no "cleaning" option for us.

I've read quite a few threads that seem like the poster is a "developer" or a "programmer" who wants to be a DBA, but has no clue what to do....

Thanks for the tip about Log Rescue. I didn't realize it is now a free tool. (I've been trying to get my employer to spring for the whole...

The only thing that happened was one of the developers ran a DTS export of table data from production to test. There was definitely NOT a script that was...

We use NOLOCK in quite a few of our reports (those that are used in production for work lists and error checking). This avoids the case where a report...

MIJ (6/24/2008)

---

I found this while running a Profiler trace and I'm trying to decide how worried I should be.

Select sectionID, heading from ordered where virtualSectionID_p =

'003;DECLARE @s-2...