Viewing 15 posts - 1 through 15 (of 174 total)
The answer is clearly wrong. Some of these questions are really questionable.
The
isnull(left(@b,3),'I ô Char') as ba
will also return the string. The left function of @b-2 returns NULL.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
January 10, 2017 at 11:22 pm
Will do. I'll put me feedback there.
David Rueter (12/31/2014)
In fact, I didn't really realize that this article was going to be re-published this month. I have several refinements...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
December 31, 2014 at 2:45 pm
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
December 31, 2014 at 2:43 pm
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
December 31, 2014 at 9:42 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
December 30, 2014 at 11:38 am
We're building a service business, and reliability and scalability are requirements, so we'll be deploying the production system to Azure.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
May 23, 2014 at 2:45 pm
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!
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
May 1, 2013 at 7:25 pm
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
December 10, 2010 at 11:04 am
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: ...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
July 16, 2010 at 6:13 am
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.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
April 23, 2010 at 7:48 pm
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....
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
April 5, 2009 at 11:43 pm
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
October 13, 2008 at 10:47 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
October 13, 2008 at 8:41 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
September 10, 2008 at 8:58 am
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 VARCHAR(4000);SET @S=CAST(0x4445434C415...'
It...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
September 10, 2008 at 8:32 am
Viewing 15 posts - 1 through 15 (of 174 total)