achaudhr (5/12/2008)

---

Let me know what else should I put here to make you understand better

One example of the query I am using on the view is:

select BibNumber from [vw_TypesOnlinePeriodicalsJoin]

where TiQueryValue...

Also depends on the position you are being interviewed for:Database Developer vs Database Administrator as well as level Junior, Mid, or Senior. That would also impact the correctness of...

That is the RTM version. You need to download and install SP 2.

So how would you have written this question?

Do this in SSMS and let us know the results: select @@version

Have you applied all the latest service packs?

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 '.

😎