SQL

...now browsing by category

 

How to convert ntext to nvarchar(max) in SQL 2005 – the right way

Tuesday, August 5th, 2008

Today, I found this very very useful blog on how to convert ntext fields to nvarchar(max) in Sql 2005. Apparently when converting a field from ntext to nvarchar(max), SQL Server does not change the internal structure and this is bad as the performance slows down significantly. However the following blog has got a simple fix to make SQL do the correct change.

http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx

Written by Deepak Vasa - Visit Website

Six steps to secure sensitive data in MySQL

Wednesday, August 9th, 2006

I found this interesting article on Builder Au the other day. If you are using MySQL extensively then it’s an article worth reading.
Six Steps to secure sensitive data in MySql

Written by Deepak Vasa - Visit Website

Flattening Out Data with One of the Coolest SQL Tricks Ever

Wednesday, June 7th, 2006

Recently, I was wondering if would be able to join multiple rows returned from a select query in to a single csv row. To my surprise, I did find a solution, it’s very simple and I really find it cool. For all those SQL junkies..there check this link out.

Flattening Out Data with One of the Coolest SQL Tricks Ever

Written by Deepak Vasa - Visit Website