Browse by Tags
All Tags »
SQL Development (
RSS)
The tens (probably hundreds) of thousands of sites being affected by the automated SQL Injection robot ( http://www.computerworld.com.au/index.php/id;683627551 ) will almost certainly have one thing in common - they didn't in the most part use stored...
Using non-deterministic functions in CTE's gives incorrect results, this follows on from two things - Itzik Ben Gan has raised a good Connect item that highlights a problem with NEWID() ( https://connect.microsoft.com/SQLServer/feedback/ViewFeedback...
I cannot emphasise enought the importance of understanding the absolute basic security principles when developing applications that connect to and run SQL against any database product. If you are doing application development that requires database access...
Using the ROW_NUMBER() function in a non recursive CTE gives a very big performance degradation because the Sequence Generation is executed not once as you'd expect but for once for every row in the anchor starting results, example - if the anchor...
Unless you are using recursion then the Common Table Expression sucks and you shouldn’t use it; the big problem is that the SQL in the anchor is repeated rather than spooled into a work table. In the last article I went through the basics of the Common...
Recursion in Common Table Expressions (CTE’s), how does it work? How can I use it with the adjacency list model (parent / child columns)? In this blog entry I show how recursion works, how to use it with the adjacency list model and talk about other aspects...