i forgot the table names, but all the data is in msdb. you can write a few scripts to get the data. my new toy reporting services and if...

does it have a SQL agent

i think i read about it a few months back but didn't read anything about a sql agent like netbackup

VSS is for multiple data backups a day and usually used with SANs. say you need to backup a few times a day but all existing technologies are too slow...

i've been using Netbackup for almost 10 years now and have been managing it for 3-5 years in addition to being a DBA. it's very easy to learn, very easy...

first netbackup

it's very flexible and centralizes administration. we only have 30 SQL servers or so but if we had to keep track of backups on each server it would drive...

interesting

i have two databases that are replicated and generate tens of millions of commands a few times a month. Most of the db is deleted and new data inserted continuously....

i've used Veritas/Symantec Netbackup for almost 10 years now. it's buggiest piece of software i've ever seen but i'll use it over native SQL backup any day. The old Computer...

are the log backups set for no truncate? i don't do log backups in my environment, but I think there is a setting where it will back it up and...

Phil Brammer (11/5/2009)

---

SQL Noob (11/5/2009)

isn't that going to be caught in testing?

when we were getting ready for sql 2005 we found our developers had written code that looks like

select...

sorte.orm (11/5/2009)

---

I asked why "select *" is such a bad thing, and as far as I can tell there has not been any single answer that was good imho. ...

David Betteridge (11/5/2009)

---

Here is one reason why I think select * can be bad.

Lets say that you have two Tables as below which can be joined on ID = ID2

create...

sorte.orm (11/5/2009)

---

Exactly why is "select * " not a good idea? I searched for articles with that tag but came up empty? I can't really see any reason...

best advice i can give is don't think into the questions too much and make pretend it's Microsoft World where the MS product is always the best choice or the...

we just migrated a server to new hardware and SQL 2005 from 2000 and got rid of a lot of openrowset code in the process. One reason is there is...

is there any hard documentation on what the tipping point is for an index seek to become an index scan? is it 5% of rows affected, 10% or some other...