- Why don't you just directly 7zip your existing full backup file(s) ?

If you precede your fullbackup with a logbackup, wouldn't your fullbackup be smaller ?

- using 7zip, you can...

the columns of both queries are not in the same order.

Keep in mind SQLserver doesn't map your columns by name but by ordinal position.

That is the ultimate, one and only valid reason to...

I guess you're running "standard install scripts" using sqlcmd.

In your dos command just use:

rem using windows authentication

sqlcmd -Syourserver\yourinstance -E -s"create login ..."

Check out SQLCMD in books online for all parameters...

With regards to SSIS, I always advise a team of programmers to learn it, just like they would learn any other programing engine.

It is very powerful, but there can...

Did you notice they published a "who is coming' at SQLPASS ??

http://www.sqlpass.org/summit/na2010/Connect/WhosComing.aspx

and I'm on that list :w00t::cool::hehe::-D:smooooth:

MPs were the most "forgotten" topic with hotfixes and service packs. (e.g. the sql2005 sp2 fiasco having a CU1 within the week)

- Remove all the hints and tweaks you use with sql2000 !

- check out the graphical execution plan and see how it proposes for new indexes. Keep in mind you'll...

we use no maintenance plans but schedule our own backup jobs using sqlagent. In the past there have been troubles with MPs, and many people switched to their own controlable...

Indeed ... that's a very nice toolbox item :w00t:

LutzM (10/22/2010)

ALZDBA (10/22/2010)

Jeff Moden (10/21/2010)

Thanks for the input, Johan. Heh... from what I've...

- How to resend email in Database Mail? http://www.sqlservercentral.com/Forums/Topic673403-146-1.aspx#bm793953

and off course also my troubleshooting script:

use msdb

go

/* is dbmail config activated ? */

Select *

from sys.configurations

where [name] = 'Database Mail XPs'

go

exec sysmail_help_queue_sp...

To get you started .... assume every documented pigeon has one male and one female pigeon for parents.

Attached a little brainstorm to start with an experiment on the hierarchy datatype.

Jeff Moden (10/21/2010)

Thanks for the input, Johan. Heh... from what I've seen, even...

Nice article, Shaun.:smooooth: