Noooooooo! I got it wrong and I was doing sooo well! 😀

Excellent question, first QotD in a long while that actually made me shift into a sitting up...

Not wanting to be antagonistic or anything, but given the question and answers (ie, what the question is trying to get across), and the fact that the STRONG tag is...

Hi Mike,

Try using the following in the .sql file:

declare @BackupDest varchar(100)

set @BackupDest = 'C:\MyDB\' + cast(year(getdate()) as char(4)) + right('0' + month(getdate()),2) + right('0' + day(getdate()),2) + '_MyDB.bak'

BACKUP DATABASE MyDB...

Thanks Dugi,

Although I was a little premature with the posting (I've heard it happens to everyone and it's not a big deal), the query should have been:

--

-- Query

--

select coalesce(t1.CallDate,t2.CallDate,t3.CallDate) as...

Well I enjoyed myself, that's the main thing! 😀

Hi Byron,

It's a bit difficult to get the requirements you are after exactly right without seeing some test data / structures etc.

From what you have said though, it looks like...

Joseph Fallon (6/11/2009)

---

...

select * from [investing fund transactions] where allocation_date > '2009-06-01'

and prealloc = 1

Returns 50 records, uses index

select * from [investing fund transactions] where allocation_date < '2009-06-01'

and prealloc =...

It's not unusual for another copy of the production database to be placed in the production environment as part of the nightly backup routine, then this second copy be used...

Erm... "Either char(1) or varchar(1) may be used. Both would allocate 1 byte of space which would be used. [If there's no data in the variable, varchar would...

Hi Mark,

What George is saying is that the concept of Users is in the database, and Logins is at the server level. When you backup the database, you are...

Hi Mark,

A couple of quick questions; Are you restoring these backups to the same server that they were taken on? Also, is the user in question an SQL...

Look at it this way, it's nchar varying. So if you were to follow it to it's logical name (varying char = varchar) it should have been called a...

usman.tanveer (5/14/2009)

---

Thanks for this query, but the problem is in actual table i have tons of columns so i cannot use MIN,MAX for each of them

(for simplicity i gave...

In that example grouping by ID and using MIN or MAX on the other column will do it.

If there are a lot of cols and you need them all to...

Chris Howarth (5/13/2009)

---

I think that the question should have been re-phrased slightly, from :

"SQL Server 2008 has which new features/keys for database encryption"

...to:

"SQL Server 2008 introduces which new features/keys for...