Stephen Wolfram (inventor of WolframAlpha among many other things) already does 'life logging' - here's a quote from a revent interview with him:

"I'm an information pack rat," he confesses. Recording...

my code was in response to this question:

I want to split the string as below

<all chars-3> space <last 3 chars>

Eg: "ABCDEFG" should appear as "ABCD EFG"

"ABC DEFGH" should appear as...

another method...

DECLARE @txt VARCHAR(20)

SELECT @txt = 'helloALL'

select STUFF(@txt,LEN(@txt)-2,0,' ')

🙂

Thanks for the additional 'speed tricks' Jeff... 🙂

Btw - how does the performance of the 'FOR XML' method of extraction compare with other methods?

Also, the last line of the above...

...or to remove the trailing comma:

DECLARE @emp VARCHAR(MAX)

SELECT @emp = CAST

(

(

SELECT [Empid] + ','

FROM yourTable

WHERE LEN([Empid])>0 AND [Empid] IS NOT NULL

FOR XML PATH('') ...

how about...

SELECT [Empid] + ','

FROM yourTable

WHERE LEN([Empid])>0 AND [Empid] IS NOT NULL

FOR XML PATH('')

is that method any faster?

Very true re: toasters - and just about all other consumer products

The problem is also that many companies (i.e. the people in charge of running them) are only interested in...

@steve-2

How ironic would it...

Hi - if the job contains one or more schedules, you may find a clue by running this query:

SELECT

sp2.[name] job_owner

, sp.[name] scheduled_by

, j.[name] ...

my mistake - I didn't check to see which version of SQl you were using - apologies

It works well for SQL 2005 though! :w00t:

This will return a comma separated list:

SELECT ',' + [columnName]

FROM [TableName]

WHERE id = @value

FOR XML PATH ('')

I have tested a similar query which works ok

Sounds like you are running the query against one of the system databases such as 'master'.

Make sure that you run the query against the database whose tables and columns...

Similar situation here to that mentioned above by Ross

I think that one of the main reasons that cursors are used is familiarity with procedural code rather than set-based code...

ssismaddy:

The job used DBCC SHRINKDATABASE - so both database and log files were shrunk.

I have considered shinking the logfile after reindexing - but decided not...

Hi Michael

I'm running transaction log backups every hour - which has been sufficient to maintain a relatively small log file (500Mb) for daily transactions. The growth of the logfile to...