tommyh (8/6/2012)

---

So here i was thinking this was a rewrite of the question we had 2 questions ago, since this question had the varchar(50) on str4 which would have fixed...

I mostly use CTE's to generate a specific number of ordered rows.

This is something I would need for example when:

I want to return a row for every day within a...

I believe the job history information in MSDB is only updated upon completion of the job.

To see jobs that are currently executing, you need to execute the sp_help_job system stored...

Thanks for the question Hugo!

I had to research the XML indexes again... not something I use.

Interesting thread.

Combining my favorite parts from all replies I think I would now do something like this:

DECLARE @Number Decimal(10,2)

SET @Number = 12345678.90

DECLARE @Number_String VarChar(25)

SET @Number_String = Convert(VarChar(25), @Number)

;WITH

T1 AS...

If I recall correctly, most of the enhancements pertained to SSAS and SSRS. I believe the database engine related stuff consisted of a few added features that would be...

How is this for a novel approach?

DECLARE @Number Float

SET @Number = 1234.56

-- Create a string version of the number

DECLARE @Number_String VarChar(250)

SET @Number_String = CONVERT(VarChar(250), @Number);

-- Create a...

If it's loaded all at once from an import process and truncated afterwards, then a PK probably would only add extra overhead when loading. I'd only add indexes if...

Too bad about the string length issue, as it was a really good question otherwise.

Nice question!

There shouldn't be any need to shrink the log file while doing the inserts. This just adds extra overhead as the log has to auto-grow back out as records...

SSIS isn't really cluster aware. There's a work around using the config files to set it up on each node of the cluster so that it sees packages from...

L' Eomot Inversé (8/1/2012)

---

I got it right, but I don't like this question.

Where (if anywhere) is it dosumented how that flag-byte 7 behaves? Nowhere, so the question...

GilaMonster (7/31/2012)

---

Won't help here. Updates are fully logged in all recovery models. A single update uses...

Is this a one time thing?

You could do a full backup, change your recovery model for the database to SIMPLE, do your updates, change recovery back to full, do another...