Yes and no. Yes I have written a lot on this...

You are using ANSI standard style coding when using the JOIN...ON clause. The other style is the old way of writing SQL. Works fine in SQL Server 2005...

Robert Domitz (5/9/2008)

---

I would love the time to write. Unfortunately, with two children, a wife who works full-time, a full-time job and a ranch to run, there is not...

So, would you improve the question, or the answers provided? To take this into an interview environment, I would be looking to see if someone knew that there were...

True, YMMV, but for our PeopleSoft application where I have tempdb on its own drive with multiple files, nary a blip. It's big enough that it doesn't grow, and...

Jamie Longstreet (5/9/2008)

---

When I was attending school [nearly a million years ago], I never appreciated trick questions and at this stage in my life I cannot recall any of those...

From what I have read, creating multiple files for tempdb helps even if they are on the same drive. I have a production server setup that way and the...

I have purchased many SQL Server 2005 books (none of them study guides), partially read some of them looking for specific information as needed. I'd like to take the...

Play with the query a bit, you'll find it simple to get the ' into it. Something like this ''' instead of '.

😎

Properly used, UDF's good; improperly used, UDF's BAD.

Comes down to an "It depends".

I have a set of tvf that allow me to do As Of queries against our ODS database....

Anders Pedersen (5/8/2008)

---

Kind of the same as I hesitate when people with years of experience suddenly go and get one of the MS certifications. I mean. ...

Use this as a starting pointing:

DECLARE @Query varchar(8000), @ColumnName varchar(50), @vho char(6)

--SELECT @ColumnName = ChannelMapName

--FROM myTable WHERE idNum = 1

--SELECT @vho = vho_cd

--FROM myTable WHERE idNum = 1

set @ColumnName =...

Do you know how the data was encrypted?

😎

Frank,

That sort of helps, but doesn't. The output sample at the top of the post doesn't match the sample data at the bottom. I am a visual type...

Not sure where you are looking in BOL, but my local copy matches the version at Microsoft, and it clearly discusses 5 system databases, including the Resource Database (mssqlsystemresource.mdf/mssqlsystemresource.ldf).

Here is...