[quote-0

Use CROSS JOIN when you really do want a cartesian product. Use INNER JOIN when you want exact matches between 2 or more tables, use the various OUTER JOINS when...

Perry Whittle (4/9/2009)

---

No George, the whole point is this

your master database is corrupt, you cant start sql to restore the database. You dont want to rebuild or you cant cos...

Perry Whittle (4/9/2009)

---

larry Hennig (3/13/2009)

---

The problem I desribed is that you cannot recover them unless SQL Server is running and you need at least master.MDF & master.LDF to start SQL...

then your plan is basically fine except you don't need to copy the mssqlsystemresource files back from your backup, the resource database put in place by the install will be...

Tracey....

so, you are trashing an instance, having already saved away your system database files?

then rebuilding the instance with the same name to the exact sqme release level, followed by putting...

It all depends on what the full end to end process of connecting to the application is. They may be going through web servers, app servers as well, the holdup...

biswas4444 (4/8/2009)

---

I am trying to upgrade a SQL 2000 server to SQL 2005. I have ran the upgrade adviser and got the following task that need to do first:

1) SQL...

that's a common assumption about DBA's in itself Manie 🙂

that would do it, as long as you have a backout strategy.

If you are archiving a LOT of data or there a lot of duplicates to delete you could hit...

MSSQL is no different to mainframe databases, its always good to test your code first and ensure you get the results you want, so I would backup the database, copy...

controversial marios, people at work saying they don't need dbas to do backup\restore now they have an expensive tool and need to justify the cost? 🙂

I think there are three...

Paul Paiva (4/6/2009)

---

Nice thought-provoking article. It gives me the opportunity to voice a related opinion...

It seems to me that any good DBA would take pride in also being a...

Hallowen problems occur on October 31st.

Its when a piece of code scares SQL into stack dumping.

Fix is to wait till next day and re-boot.

good article with a lot of truths in it. It is also often true that there is more credit to be gained in fixing a high profile incident then preventing...

this script, found on this site, claims to reverse engineer the SQL to re-attach databases using create..for attach command

http://www.sqlservercentral.com/scripts/Miscellaneous/30795/

haven't tried it myself.