I must be missing something - what does this have to do with SSIS? It looks more like web development? Can anyone explain please 🙂

I also had the problem mentioned by several others - that I needed to hold Ctrl while clicking on the link - so I answered nothing!

Unfortunate for the poster of...

Great question - made me LOL!

Thanks to everyone who submits a question - I hope that when I feel able to submit one, I won't be shot down in flames...

I shall be reading Jeff's articles as well - as I am one of those that has trouble thinking set based (I can code a solution to this in COBOL...

Best performance tip I've read all week 😀

I clicked on the answer that said "right answer" and guess what, it was right! If only all QOTD were this easy. Mind you, it could have been a trick...

One thing that caught us out recently with replication is that you need to back up the replicated copy of the database, or else it's log file will grow and...

Nor me at present, but it's something to look forward to!

In SQL 2000 you'd use SYSOBJECTS; unfortunately the fields in the query aren't avialable in SQL 2000 so you'll need to wait until you've upgraded :sick:

If anbyone does know of...

I think with R2 just around the cormer, I'd wait for the first SP for that before upgrading. After all, will Microsoft release SPs and CUs for non R2 SQL...

This reminded me of something that has been puzzling me recently about clustered indexes. If the leaf level of a clustered index actually is the table's data itself, does this...

I've been struggling to learn the ropes as a DBA for nearly a year now and a simple quick intro like this would have been useful to me when I...

Option 6 fooled me too - but I'm always glad to learn more about the differnces between ISNULL and COALESCE, since they often appear to be interchangeable!

Certainly an interesting idea, but as some others have said I woul dhope the DBA would have the authority to vet any code gpiong into the live environment.

I wasn't sure how the exist() method worked, so tried

"where @xml.exist('//Book[Price < 2 ]') = 1"

and got no rows output, so understand now that this the exist() method must look...