Find the Windows Server Name

I was working with SQL2000 on a windows cluster.  I needed to write the results of a query to a test file on the local drive.  I was using @@servername to get the server name to write the file.  Unfortunately that appends the instance name and gave me a problem.  So I went looking for [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments
AD

SuperStart

Today was the end of an excellent conference for 4th, 5th, & 6th graders.  SuperStart is a production of CIY.  If you have a child in that age group and you have the opportunity to go, it is so worth your time.   If your church is hosting the conference it is a total blast to [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Update: Degrees of Parallelism

Well, it’s been 10 days since I started to play with parallelism on this server.  I have gotten the self blocking to stop.  My CPU utilization has stabalized and my phone is not ringing.  So I think that the issues is mitigated.  I finally settled on Max Degrees of Parallelism of 2 and the Cost [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Things You Know Now

Denny Cherry tagged me in a blog thread with a question asking “What do you wish you knew when you started?”.  So here you go.  As you know I am still relatively new to the SQL profession so I’m still figuring out what I don’t know.  I seem to find several every day, so I’m [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Starting up database ‘SomeDbName’

I love it when I learn something within a half hour of getting to work.  I had an unrelated alert on a vendor supplied database server.  As I was investigating that problem I came across two things.  One was funny, one I actually learned something.  First the funny: they had named the sysadmin account ‘God’.  [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Degrees of Parallelism

If you are expecting a deep, well researched, thorough explanation of degrees of parallelism and cost threshold for parallelism you have come to the wrong place.  I’m sorry.  Hit the back button and choose a different link.  O.K., now that I’m alone again, I can get into my issue.  I have a vendor application, which [...]

Tags:

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments