I wouldn't 😉

But if I did (excuse the rushed code, it's 3am):

create table jan (a int)

create table feb (b int)

insert jan values (1)

insert feb values...

See http://www.sqlservercentral.com/articles/T-SQL/63681/ for an excellent alternative to the confusing PIVOT command.

/Paul

Hey there Abhi,

There are lots of ways to achieve this, but could you tell us a bit more about what it is you are doing, perhaps with some example table...

This is not a serious post - don't do this!

Yet another option (though not a good one!) would be to construct a table valued function to return the correct data...

Hey Jeffrey,

The last time I used...

Hey guys,

Once or twice a year, someone from some SAN vendor or other pops in to claim that SQL Server backups can now be done automatically by their SAN solution,...

Just...

:w00t: OMG no. Please no-one look upon this as an 'imnprovement'!!! :w00t:

It's...

Jeff,

You are so right to point out the data-consistency advantage of the computed column. I guess I could add a constraint or something to simulate that benefit, but it...

peleg k (4/12/2009)

---

is there a way to make a query on a Dynamic table name like this :

Select * from Messag2008+@MonthName

but withought using a dynamic query which will be activated...

Hey,

You might also want to take a look at Change Data Capture in SQL 2K8 - in case it's an appropriate tool for the job you need to do.

/Paul

You could use a DDL trigger (DDL_SERVER_LEVEL_EVENTS) to identify which process and command is changing the recovery model.

Something that logs to a table based on the following might work:

CREATE TRIGGER...

Hey...

Hey Jeff!

Well presented and thought-provoking article, as millions of others have already said 😉

I do love a performance challenge though, and the figures showing that PIVOT was slower than the...

Hey Flo,

Yeah - it's one of those articles I keep going back to: for some reason I can never quite remember all the details verbatim 😉 😀

/Paul