Lynn Pettis (11/17/2009)

---

I see that the question has been rewritten as it is now using variables that are set first and changes the word same to equivalent.

Now that the question...

cengland0 (11/17/2009)

---

David_Simpson (11/17/2009)

---

I did not even bother to try and analyze the queries, once I read that the GETDATE() function was executed 4 different times, the only possible answer was...

Lynn Pettis (11/17/2009)

---

Okay, I give up. No one is really paying attention to the concept that the question was trying to bring out. Everyone is concentrating on the...

I did not even bother to try and analyze the queries, once I read that the GETDATE() function was executed 4 different times, the only possible answer was false regardless...

Good question. I missed the char(10) limitation. I did not know that COALESCE does not limit output size while ISNULL does.

coalesce(convert(char(10),@MyDate,101),'Date is Null') = not limited to 10...

I think this is a solid question that does not try to trick anyone but shows a simple example of a inequality comparison that would have been easier to read...

Searching this site for SQL 2005 Security; Brian Kelley and others have written several really good articles and forum responses.

Some other areas for information include:

SQLSecurity.com

MS SQL Server 2005 Best Practice...

DBCC INDEXDEFRAG is an online process for SQL Server 2000, although it does not actually rebuild the indexes. Instead it tries to defrag the leaf level of the indexes...

The SQL 2000 optimization maintenance plan executes DBCC DBREINDEX which will rebuild the index and cause table locks. Use DBCC INDEXDEFRAG instead. BOL can give you the pro's...

Thanks for the validation. I'm planning on going down the Express or Workgroup path if more resources are needed.

- David

The idea of automatically documenting a database is a fantastic idea, especially when you store information in the extended properties. Unfortunately SQL Doc is not very flexible and the last...

The script actually returns the amount of time since the database was created. Since the tempdb is created every time SQL Server is started, this gives you the up-time...

Well written article and new way of working with Configuration tables. I like the trigger used to track changes in the configuration table. To me, though, the data...

I was not 100% sure of my answer, but I picked the one that was not capitalized likt the others. And I have never seen a data type with...

Very good article... no doubt your co-worker owes you some extra beer money 🙂

Not picking on your scripts, rather this is something I've been wondering. What is the advantage...