Viewing 15 posts - 226 through 240 (of 526 total)
Lynn Pettis (1/15/2013)
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
January 16, 2013 at 8:22 am
Lynn Pettis (1/15/2013)
Just curious, do you expect DBAs to have the syntax of the various DML statements memorized?
No. I just expect them to know the DML verbs at least. The...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
January 15, 2013 at 11:13 pm
I'm mostly a production DBA. Keep 'em up, running and tuned. I'm also responsible for front line troubleshooting of our software, and database issues. I've done about 15 different DB...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
January 15, 2013 at 9:03 pm
The one thing I've done a lot is is created a scheduled task based off the sp_help_revlogin SP. It dumps the data to disk every 8 hours. Then...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
December 14, 2012 at 10:28 am
Being a generalist in many areas doesn't preclude you being an expert in one, like T-SQL.
I advertise myself as a production DBA. I can sit around and write T-SQL SP's...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
September 10, 2012 at 8:29 pm
I have found that once you get to a certain level, and you don't limit yourself to be strictly the DBA world, the unemployment worries drop off significantly.
I have a...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
September 9, 2012 at 11:55 pm
The nearest I could find to it is the blog item that was cited in the article.
But if you look at the dates on the blog it was probably in...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
August 31, 2012 at 1:37 pm
Do you have replication going?
However, there was a bug in some versions of SQL 2005 that could result in a log reuse wait of Replication
This bug was also present...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
August 31, 2012 at 10:57 am
L' Eomot Inversé (3/14/2012)
I don't like seeing the explanation of QotD being used to plug an expensive textbook when the question is adequately covered in BoL.
Did you happen to note...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
March 18, 2012 at 10:01 pm
I know I'm late to the party -- I'm guessing that you have your database files on a netapp san unit.
I'm early on in this theory so take it with...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
March 15, 2012 at 6:37 pm
Well fortunately this is no longer my problem to solve. (No longer with the company.)
I went with a reprocess solution. I can't remember the exact, but I had it import...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
July 9, 2010 at 11:13 pm
There's no tool to either check which pages don't have checksums, or to put checksums on all pages - unfortunately.
I'm working on something that will do that - but it's...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
May 11, 2010 at 7:24 pm
I was able to install SQL Server 2005 Standard on my machine by using the cmd prompt.
runas /user:administrator "msiexec /i C:\MyPath\SQL_2005_Std_x64\DISC1\Setup\SqlRun_SQL.msi"
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
April 24, 2010 at 10:27 am
Sweet code.
On the
SELECT @a = (SELECT SUBSTRING(@a,1,LEN(@a)- 1))
--Trim off the final comma; I'm sure there is a better way to do this...
Why not just do a
SELECT...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
July 31, 2009 at 3:16 pm
I'm trying to use this in SQL 2005, and am running into an issue with the sp_MSforeach_worker. It is only setup to handle tables or databases.
if @worker_type=1
set @local_cursor = hCForEachDatabase
else
set...
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
July 16, 2009 at 10:09 am
Viewing 15 posts - 226 through 240 (of 526 total)