WayneS (9/16/2011)

---

Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely...

I think the topic on VLFs...

The use of windowed functions comes to mind as well (row_number).

Have you checked for other running jobs at that time?

Is the udf being snapshot replicated to the server you are working from?

GilaMonster (9/16/2011)

---

I suspect this got lost in all the 'helping Grant abuse SQL' posts...

Another request:

I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction...

Careful you idiot! I said across her nose, not up it!

Cadavre (9/16/2011)

---

Try it like this: -

DECLARE @str VARCHAR(255) ='rajneeh kumar is working in technext'

SET @str = ' ' + @str

SET @str = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@str, ' a', ' A'),

'...

HowardW (9/16/2011)

---

The theory does actually work, it would just be useful if 5 seconds of care was taken before posting to make sure it was formatted correctly. If you just...

This is a good topic for the question. I think some tweaks to the question as pointed out by vk-kirov could make it a better question.

What is the desired output supposed to look like? Please provide a sample.

SQLTestUser (9/15/2011)

---

I am trying to add a null column and set it to a default value of 0

with

ALTER TABLE X add acolumn smallint NULL Default '0'

but when...

What is your exact error message?

Dotted lines add a bit of complexity for certain. If the group at each end of the dotted line understands the objectives and the scope of that dotted line...

Fixed - copy paste mistake.

The Pivot should help you with this.

Here is an article with examples:

http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/