Service broker, although it's asynchronous.

It's true that databases can have their own collations, but you can run into problems if they don't match the tempdb collation - it depends on how your code is...

Are you learning from books alone, or do you work with SQL2005? If the former, then you might get through by skimming the books in the few days before...

I suspect the best approach is to completely reanalyse the index strategy for the table and see how well the results match the existing indexes - that's the only way...

Standard edition and below will work on XP - so that will provide the most functionality if you are only concerned with XP, 2000, 2003, Vista. You then need...

I just listened to the radio the other day, the host was talking some company complained they could not hire good employees. Just liked many IT departments complained they could...

Assuming that they are all running the same queries with roughly the same parameters and result set size, SQL probably isn't the issue. Depending on where they are VPNing...

Off the top of my head, the backup was written to multiple files but you are attempting to restore from only one of them.

Checksum has a possibility of producing the same result from different inputs ....

http://msdn2.microsoft.com/en-US/library/ms189788.aspx

MSDN recommends using HashBytes (although still not guaranteed), but to be entirely accurate you would need...

Congrats. I take it next week. Is the pass mark 70% as with the 431? The self-paced training seems to want upper 80s, albeit it is straight...

I would keep 4 drives in raid 10 (user DBs, tempdb), use 2 drives in raid 1 (logs), maybe use the other drive to mirror the OS drive (assuming it...

I think Brandie meant how many physical disks are used in the raid 10 configuration. At a minimum it will have 4, so one possible solution would be to...

When you say drive G is "just a drive", do you mean single drive with no RAID? If that is the case, you need to consider whether you put...

I think your alternative would probably work as well as anything ... could you include the records to be deleted into the XML files? Presumably the process that imports...

What specifically is preventing your package from executing?