It may depend on how the application is written, but for the standard connection window you can test by creating an empty file with an extension of .udl, and then...

You might want to look for tables in tempdb that are not temporary, ie an application is creating permanent tables there.

Also, does your server have either of the...

Information regarding SQL2005:

http://sqlblog.com/blogs/linchi_shea/archive/2007/06/30/performance-impact-of-procedure-calls-without-owner-qualification.aspx

Information regarding SQL2000:

http://sqlblog.com/blogs/linchi_shea/archive/2007/07/05/performance-impact-of-procedure-calls-without-owner-qualification-sql-server-2000.aspx

I'd always recommend it as the best approach, but any gains you might see will depend on how your applications are set...

Prometric handle all the MS certifications now (in the US) ... http://www.prometric.com/default.htm

The exams are $125 each. If you think you want to cover yourself in the event...

- PL/SQL is miles ahead of T-SQL and always has been. Having just built an application that will work on both Oracle and SQL Server I could write an...

Sandy,

Open up configuration manager on the server and you will see the list of SQL services, and the accounts that each of them are running under. Because backups are...

As Amu stated, its most likely that you are appending to an existing file.

Regarding differential backups, they are purely a copy of all pages that have changed since the last...

Not sure about different versions but the ISBN-13 of my copy is 978-0-7356-2271-5

As far as whether the questions are sufficient - IMO they are more than sufficient provided you understand...

Ha, good question .... I thought it was from an article on this site, possibly a post, and I think I remember linking to some Microsoft document. I haven't...

Yes, I would highly recommend that you investigate collations further before making any changes.

Two major aspects that you need to be aware of are:

1) SQL collations are marked...

I don't believe the full backup needs to be available, it just needs to have been created.

The message refers to "sampledb" - is this perhaps a database created...

I found the self-paced training questions to be a good grounding. 431 in particular seemed to have much harder questions in the book than on the exam. If...

By processor settings being correct, I assume that you mean the affinity settings are correct. Is max degree of parallelism (server properties, advanced) set to 0? Also bear...

Michael Valentine Jones (12/11/2007)

The problem with that design is that nothing prevents inserting another row in the table, and causing major problems in the application.

As I mentioned in a previous...

Check out the actual execution plans for #2 and #3a together .... they both come in at 50% relative cost (50% vs (42+8)%).

The difference is in the compute scalar operation....