David Walker-278941 (10/7/2009)

---

Yet another article that makes people think that table aliases (t1 and t2) are part of the required syntax. This first Join statement:

SELECT t1.key1, t1.field1 as Name,...

is there any performance difference doing a union all compared to a join when you need to get all the rows from two or more tables? i have a database...

finally forced myself to start studying and bought the MS Press cert book. I checked out MeasureUP online but the price was the same as the physical book, and i...

i was looking at the MS Press book but might just do the MeasureUp online 30 day rent thing. I'll have to check ebay and amazon used prices for the...

i get these as well and i usually go and try to fix them

you can try in SSIS to move all the garbage rows that error out to a separate...

on the subscription reinitialize it. then start it manually to make sure you get the message that the snapshot is not available.

run the snapshot

run the log reader

start the subscription and...

we're in the process of moving a sql 2000 server to sql 2005 x64 and had to find new third party drivers because some of the drivers on the old...

when we did it we created all the logins manually and then ran sp_change_users_login after we restored the databases

we had an issue where we couldn't read from MS Access on a x64 server. we installed office 2003 on the server and it worked fine after that

we have 1TB databases on Standard edition and 100GB databases on EE. we use online indexing mostly for EE but with the speed of today's hardware it might be cheaper...

Netbackup 6.5.4 is a lot better

i had some strange problems with older servers mostly running windows 2000 and earlier builds of SQL 2005 or SQL 2000 and 6.5.4 seems to...

billy.jones (8/12/2009)

---

thank you both for your replies.

I've tried using the copy database wizard but i get told that i cannot copy a database to an instance older than 2005. i...

are you using a database agent for your tape backups? Netbackup supports data file backups. Why not just backup the files to tape and do the SQL backups to disk

hardware is cheap

we are configuring all our new SQL servers as x64 unless there is a specific need for 32bit. even then we just try to dump all 32 bit...

going to try a different strategy

It's only 5 million rows or so, and i'm going to create one nightly job to transfer the data to SQL and leave all DML...