Nope, sorry. Common Table Expressions are new in 2005.

I read this yesterday and wasn't sure what you're looking for. Would a common table expression work? This is derived from BOL:

WITH TableX AS

   (SELECT e.ManagerId, e.EmployeeId, 0 AS Level

   ...

If you run a query against the sys.sysobjects system view in the master db, do you still see it?

SELECT * FROM sys.sysobjects

WHERE NAME = 'sp_executesql'

If so, note the type. It's...

What are you trying to do? There is a view available, sys.foreign_keys, which shows the basic information on a given set of keys within a database. Is that what you're looking...

Yeah, especially since M:M is usually done through a third table.

Since you can only restore to a point in time you need some method of determining which transaction is your final point. You might want to check Lumigent LogExplorer or...

You have that 100% correct. As a matter of fact, the BOL says you can't mirror between two servers on the same cluster. Although, if you set up active/active clusters...

Yes, it does provide availability. The way that it was described to us when we were working with the Dell consultants on our last cluster configuration was that for high...

Are the indexes in reference used in the update queries? If so, you need those indexes. You may or may not want to rebuild them before and after (and if...

Agreed. I'd go for the partitioning first. It's complete seperate from the other architecture decisions and work.

After that, clustering gives you availability and mirroring gives you redudancy. These can be...

Hey Lynda,

We're starting up a PASS Chapter in Southern New England. It's hard work. The only thing that I've found interesting so far is how easy it is to get...

You can't really get these types of counters directly out of SQL Server 2000. But in 2005, you can reference the dynamic management views such as sys.dm_os_performance_counters. Run the select...

Yeah, I'd drop the clustered index and make the PK clustered. It's as you said, the leading edge to the PK is the same as the clustered index, so one...

You basically can't do that.

You can do something like this:

WHERE 1 = CASE

   WHEN evaluate something & return 1 or 0

or

WHERE SomeColumn = CASE

   WHEN evaluate something THEN some value

You're trying...

Hey,

Getting a design is usually very dependent on business needs, but you should be able to set up the database to accept any given start & stop time and then...