TSQL all by itself can't write out to a file. From TSQL, to get to a file you'd need to call sp_OA procedures. Otherwise, I'd look at DTS as a...

It is fast. It's not necessarily safe though. Once you've detached the files, in theory, just about anything could happen to them. What's wrong with backup & restore. I've never...

I've never actually found a situation that both required an indexed view yet was simple enough in it's design to be able to implement one, so I understand what you're...

Honestly sounds like you might benefit from an indexed view. Did you look into that instead of loading a table? Ony reason I ask is because the indexed view is...

Swing over to SourceForge.net and search for SqlUnit. It uses the nUnit test driven development approach for TSQL. It would allow for a set up step, an execution step, verification...

Sure. It's not hard. You create the database without the NDF files or the file group, just the basic MDF & LDF file. Then you add the filegroup and files...

All true.

However, the problems we ran into weren't related to I/O or memory, but rather when using the table variables (@ tables) in joins with each other and regular tables,...

Ah, well, you've just gone past my knowledge of the topic.

Good luck.

Sounds like a permissions issue. Backups don't run under your security context, but under that of SQL Server. Make sure that SQL Server is running as a network login instead...

We restore across the network all the time.

RESTORE DATABASE x

FROM DISK = '\\server\sharename'

WITH REPLACE

Works great. Well, assuming the network is working correctly, hops across domains cause it to run very...

After wrestling with all the work-arounds (and losing) we finally settled on forwarding all events from our clustered servers to a non-clustered server where we have mail nicely, safely, reliably...

Everything the last post said and...

Statistics aren't generated for table variables so their use in queries can, depending on their size, cause performance problems.

I had to all but reformat my drive in order to get the June CTP installed. You will need to, at the least, uninstall the April CTP first.

Do you get an error, or just a blank screen? I ask because I've been getting network packet size errors when trying to connect and found that there's apparently an...

I don't think it installs a full version of VS. I got VS as a seperate install and did that on top of the SQL Server install and then had...