Yes, you can define a query poorly and end up with unpredictable results for a variable. Easy enough to control for if you know what you're doing.

Select allows for assigning multiple variables at the same time. It also allows for a direct Select From Where structure, while Set requires scalar sub-queries.

There's no significant performance difference....

If you want to keep it free, eval edition and the library are good ideas.

That gives you some time to get a feel for the subject without monetary costs.

If you're...

You can kind of enforce relations between tables in separate databases by use of triggers. I say "kind of" because it's tricky to get them to really encompass the...

Nope. sp_spaceused won't work for that. I don't think you can really access that for temp tables. Could be wrong, but they're really designed to be accessed...

The second trace is the SQL 2005 default. Trace ID 1 in your case is not the default.

This means that there's something restarting the trace when SQL Server service...

No clue.

Set up a test script. Make it one that does something really, really obvious that you can test for. Then try it.

However sometimes event 'B' comes before 'A' and so in...

sparky-407434 (12/3/2009)

---

I am interested in knowing what others think of using virtualization as an HA solution. In particular what your opinions are of VMware and MS Hyper-V as alternatives to...

You could put it in a .BAT file. You could create an executable in .NET Studio that would run it. You could have it run by xp_cmdshell from...

I don't think Express comes with SSIS.

"Like" and the related wildcard characters only work on string data types, not on numbers or dates.

The way to do what you need is to assign the date to a...

The "case length" portion doesn't apply to SQL 2000. It was put in when I was writing it for SQL 2005. SQL 2005 has varchar(max) and nvarchar(max) data...

SSIS is pretty good at converting data from one format to another. Any reason to not just use that?

Anyone more familiar with 64-bit SQL connecting to Jet than me? (Wouldn't take much to be able to answer that positively.) Got a guy with a question about...