Archive

RSSSQL (44)

Date Title Comments
2010-02-03 Aggregated functions and CASE 0
2009-10-31 Selecting latest order 1
2009-09-04 The IsNumeric Trap 1
2009-07-14 Local variables and batch scope 2
2009-06-29 Sorting integers in a string using XQuery 0
2009-05-15 Using INNER JOIN/SELF JOIN to allow for smaller indexes. 4
2009-04-21 Rollback the transaction 0
2009-04-20 Transaction and connection 0
2009-03-05 Dynamic inequality checks 5
2009-03-02 Filter parameters in a Stored Procedure 3
2009-02-16 Using @@IDENTITY and SCOPE_IDENTITY() 0
2009-02-05 Drop User: The database principal owns a schema in the database, and cannot be dropped 6
2009-02-03 Select/Edit rows and Saving Changes is not permitted. 0
2009-01-09 Assign orphan users to a new login 0
2009-01-05 Cleaning a DateTime for the time portion/Converting DateTime. 1
2008-12-02 LEN() 2
2008-10-21 LIKE wildcards 0
2008-09-27 Difference in assignment using SELECT and SET 0
2008-09-01 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON. 1
2008-07-16 Linked Servers in SQL Server 2005 6
2008-06-12 Bringing a database out of Restoring state in SQL Server 2005 6
2008-06-08 UPDATE/INSERT syntax trick 0
2008-06-06 UNPIVOT and CASE to solve a problem to find the highest column in a row 0
2008-06-05 Using RANK() and CTE 0
2008-05-26 Assign EXECUTE on all Stored Procedures 1
2008-05-21 INTERSECT/EXCEPT versus IN/NOT IN 1
2008-05-18 NOT IN versus LEFT JOIN 0
2008-05-15 SQL Injection attack still going strong. 0
2008-05-11 IN versus INNER JOIN 2
2008-04-29 Partition removed by adding index 0
2008-04-24 Delete using join-queries 0
2008-04-17 SELECT COUNT Behaviour 0
2008-04-02 More table partitioning and numbers 0
2008-03-17 Table partitioning and some numbers. 0
2008-02-28 The SELECT 1 vs. SELECT * in EXISTS conondrum 0
2008-01-28 DateTime and Indexes. 0
2008-01-18 Learning about execution plans. (part 2) 0
2008-01-15 Learning about execution plans. (part 1) 0
2008-01-09 Learning about execution plans. (intro) 0
2007-12-07 Dynamic ASC and DESC and Order by DateTime 10
2007-11-28 Kill active connections to the database 0
2007-11-12 SQL: Watch those join clauses 0
2007-09-26 SQL Fun: JOIN's 0
2007-09-11 SQL Oddity 0

RSSSQL XML Bulk Load (4)

Date Title Comments
2010-02-09 SQL XML Bulk Load and line breaks 2
2009-10-22 SQL XML Bulk Load - some common errors 0
2009-07-13 SQL XML Bulk Load - basic XSD syntax 2
2009-06-22 SQL XML Bulk Load - introduction 0

RSSXML (2)

Date Title Comments
2009-07-13 SQL XML Bulk Load - basic XSD syntax 2
2009-06-29 Sorting integers in a string using XQuery 0

RSSUncategorized (1)

Date Title Comments
2009-07-26 Enabling moderated comments due to spam 0

Total

49 posts
56 comments

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen | Modified by Mooglegiant

About me

My real name is Allan Svelmøe Hansen.

I live in Denmark, where I work as a developer for hedal:kruse:brohus using SQL Server and the .NET framework since 2004.  My primary fields of expertise is back end data integration, database design and optimization. But I also work with website development as well as application/services for server and SEO of websites.

Disclaimer

The opinions expressed herein are my own personal opinions and thoughts and does not represent my employer's view in any way, nor are my results guarentees for all situations.

Content is presented “as is”, with no warranty.