Cade Roux

Cade Roux has asked 79 questions and find answers to 441 problems.

Stats

About

Stack Overflow CV

Cade Roux questions

FETCH INTO doesn't raise an exception if the set is empty, does it?
Typical Kimball Star-schema Data Warehouse - Model Views Feasible? and How to Code Gen
Why isn't .NET 4.0 covariance working in this example?
Order of XML nodes from document preserved in insert?
Slimming Down Exception/Environment.StackTrace Meaningfully
WinForms - Trying to make a background maximized form which stays in background and doesn't respond
Is there any way to make this UDF deterministic?
Strange NOOP convention?
Preventing XSS exploits using the type system as Joel suggested
At some point in your career with SQL Server does parameter sniffing just jump out and attack?

Cade Roux answers

Export multiple queries to different tables
Why doesn't Microsoft.SqlServer.Smo appear in the Add References dialog
Need help designing big database update process
View or User Defined Function?
Are less tables better than more?
What is Oracle RefCursor type equavalent in System.Data.DbType enum in C#?
How do I avoid complex joins in star schema?
Possible to insert with a Table Parameter, and also retrieve identity values?
How can I do this Spatial Query in Sql 2008?
Hash function combining - is there a significant decrease in collision risk?