New Articles have an RSS feed (http://www.sqlservercentral.com/Xml/Rss/articles) - iGoogle allows you to add any RSS feed and there are plenty of desktop gadgets that do the same

X64 and IA64 are two different 64 bit processor architectures - You need to use the one that's appropriate to your processor model (nowadays that will likely be x64)

Sounds like Parameter Sniffing. Try changing the procedure to not store an execution plan to confirm - e.g. ALTER PROCEDURE ... WITH RECOMPILE AS

It's a big subject so best...

I'm not sure there's a hard and fast rule - I tend to use CTE's first and only use temp tables if I need store intermediate results and re-use them...

Sorry, are you saying they're datetime's and you're casting to remove the time part? If so, I'm not sure if this is SARGable, but you could possibly change your method...

The main difference is that temporary tables can store statistics, but if the result set is returning less than 100 rows anyway and it's from a single statement, you may...

Eh? Where did he...

Assuming you want the dashes in fixed locations, look up SUBSTRING in BOL

There's no such thing as position 1 in table1 or table2. The order in which records were inserted is irrelevant in SQL Server and not able to be determined without...

It's not your only option, but it's one of the better ones, especially if you're familiar with .net languages.

Which edition are you using? SSIS is well suited to batch jobs,...

FYI - if you do use a CLR for this, you must set the permission set to EXTERNAL_ACCESS if it needs access to network resources.

I think your most flexible option would be to have a CLR scalar valued function that just downloads the XML and returns the data as XML, then do the XML...

End of the game I'm afraid. Your log file doesn't store any information that could...

Well, it depends on your exact scenario. Assuming you have a full backup and the log file has never been backed up or truncated since, it's as Gail's has already...

If there genuinely has never been a backup since the time the database was created, the chances of recovering the data through the transaction log are fairly slim.

I would...