Browse by Tags
All Tags »
SQL Development »
SQL Server (
RSS)
Come and join us for this great evening of developer focused content. These meetings are great opportunities to meet other SQL Server professionals, get your burning issues solved. This event brings a new slot to our agenda - the open mike slot where...
I'm forever forgetting how to do this and am currently on a project where I get a ton of CSV files daily and need to load them. The trick with getting rid of the " is to know how to escape the " in a format file. The data looks like this...
It's been a bit of a wait, but it's there now. It's already downloadable by TechNet or MSDN subscribers. Here's the press release: http://www.microsoft.com/Presspass/press/2008/aug08/08-06SQLServer2008PR.mspx More information though the...
I'm giving a Full Day Seminar on the 12th September at the University of Hertfordshire which is just north of London. For full information see: http://www.sql-server.co.uk/train20080912/default.htm This is targetted for people new to SQL Server or...
Registration is now open for SQLBits III and its FREE again. We have a staggering 63 sessions submitted for this conference far more than the previous two. Because of this and to ensure you get to see the sessions you want to see we have setup the registration...
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...