+1

Paul,what exactly you mean by that..

As we...

Nice Question

loved reading it

not sure about 2005 but in 2008 and above you can upgrade the servers without downtime.

first upgrade the mirror server

then fail-over to to mirror server

then upgrade initial primary server

Training kit books are really helpful to me...

maintenance plans are stored in msdb.

So restoring the msdb on new server should server your purpose.

http://msdn.microsoft.com/en-us/library/ff929071.aspx

this might help you.

Good question..and I have seen this behavior earlier as well.

As per BOL, "*" is returned when we try to convert to char and varchar and

Error message when try on convert...

its new function added in SQL 2012

As there is lot of unallocated space then once you can shrink the file..

if it grows again then don't shrink file again.

Note:As specified by some geeks ,it is not advisable...

thanks Gail,,,I got what author is trying to say...

I think instead of clustered index he should have used clustered table to make it clear..

SQL Server uses an allocation order scan...

Writer's Explanation

3. correct answer: c

a. incorrect: When SQL...

Looks ok to me as :

null + 'Hello' --->NULL

Hugo Kornelis (7/8/2013)

---

Not a bad question, but the explanation is only partial. Here's a fuller explanation.

For varchar, trailing spaces are preserved, so the variable stores six letters plus two trailing...