256 reputation
16
bio website
location Uzwil, Switzerland
age 43
visits member for 1 year, 10 months
seen Sep 15 at 7:43

I am considered a Senior by my peers when analysing issues with

  • Microsoft SQL Server 2000/2005/2008/2012

I have knowledge in the following areas (from best to worst)

  • Microsoft SQL Server (from 6.5 to 2012)
  • Oracle RDBMS
  • Lyris Administrator
  • Stellent (now Oracle UCM)
  • EMC Networker
  • IBM Storage
  • Linux (Fedora, Ubuntu)
  • Citrix
  • ITIL
  • Joomla

My function

  • IT System Manager

Aug
20
comment Is there a way to do a textual search through all stored procedures in a table?
I like Idera's SQL Search tool which is part of the SQL Admin Toolset.
Apr
8
comment How to generate create table script without primary and foreign key in Oracle
sorry for the typo. Was on the run to a meeting. Yes, @booyaa is right. EXEC for each line is correct.
Apr
8
answered How to generate create table script without primary and foreign key in Oracle
Nov
15
awarded  Yearling
Dec
5
comment Why Does the Transaction Log Keep Growing or Run Out of Space?
I voted to delete my post, because I'll try to recreate the situation i've encountered. It might be something totaly different.
Dec
5
revised Database Indexing - Maintenance Jobs
added 17 characters in body
Dec
5
comment Join tables on a partial string match
-1 I had difficulties understanding the question from the grammatical side . I was surprised that @SQLKiwi was able to provide an answer based on the question.
Dec
5
awarded  Critic
Dec
5
answered Database Indexing - Maintenance Jobs
Dec
5
awarded  Commentator
Dec
5
comment Why Does the Transaction Log Keep Growing or Run Out of Space?
+1 well explained. I've added my favourite default error below. Happens with new DBAs.
Dec
5
answered SQL 2008 RTM Temp Tables
Dec
5
comment SQL 2008 RTM Temp Tables
+1 Well explained. TempDB contains lots of information from various sources and the SQL database engine is going to start caching (RAM usage / Buffer Cache) as soon as the users start the application(s).
Nov
22
revised Another BCP Export [Fail]ure
Added an update to BOL reference to skip columns in fmt file
Nov
22
comment using IDENTITY column with increment -1
Could you elaborate on writing to both at the same time?
Nov
21
comment Is it advantageous to scale out using multiple SQL Server instances on the same server?
It would be nice if you could provide us with more details. The way your question is currently phrased, you will only receive information on the pros and cons of instances in general and not for your specific needs.
Nov
21
answered Is it advantageous to scale out using multiple SQL Server instances on the same server?
Nov
20
comment Another BCP Export [Fail]ure
I think you can output all the fields but shorten them to zero length. I'd have to dig around in my bcp files, but that was (I recall) the solution to a similar problem I encountered with SQL Server 7.0
Nov
20
answered Another BCP Export [Fail]ure
Nov
20
comment SELECT Data Set Using Stored Procedure with BCP Error
True. How did I miss that one.