sql

Ninja coding skills

Sql Server Deadlocks are a huge topic. Simply, they occur when data is updated by two different processes at the same time, prior to committing a transaction. It can also occur on a read whilst a write is occuring on the same data. This is usually created by inefficient code, holding open a transaction longer than […]


November 5, 2012 - 8:54 am
Read more
photo

A colleague today told me that using nvarchar(max) in SQL server could be more beneficial than ntext because you can do full text searching and like commands on the field. Technet has this to say: “Variable-length Unicode character data. n can be a value from 1 through 4,000. max indicates that the maximum storage size […]


February 8, 2009 - 8:50 am
Read more
photo

We have been slowly migrating databases from SQL 2000 to 2005, and as we do so we find that the Full Text Catalog isn’t brought over into 2005. This causes lots of issues, one being backup stops working. So how do you get rid of them? To find out what tables are indexed in the […]


February 6, 2008 - 9:07 am
Read more
photo

SQL server has always had difficulty with its backup and maintenance plans in removing old backups. Until now this has been a major issue on some of our servers, each month someone has to go through the backup folder and remove the old Transaction Log and Full Backup folders. No longer – Robocopy to the […]


January 7, 2008 - 5:58 pm
Read more
photo

We have been moving sites from a SQL 2000 machine over to a new SQL server 2005 server and we came across this error: “The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (“”): Data type 0x38 is unknown” It is caused by the connection method in the […]


October 31, 2007 - 8:51 am
Read more
photo

I am just working on migrating a clients site from a third party provider over to our servers and I thought I could use SQL Management Studio and DTS to move the database. Should be easy right? connect to third party server, right click database, copy et voila! Not so, the other server is running […]


October 9, 2007 - 8:16 pm
Read more

Today we were trying to join 2 fields from different tables with a left outer join. This means that if there is nothing in the joining table the rows are returned as null. By default SQL wont give you a result in the joining request. Lets have an example. You want to get categories and […]


May 12, 2007 - 7:55 pm
Read more
photo

I have seen many different ways of doing this, but to my knowledge this is the most accurate way. Using SQL you can have your database return the distance between 2 sets of Lat and Long points, and using some math functions also take into account the curvature of the earth. Admittedly if you are […]


April 9, 2007 - 9:32 am
Read more
Login
Log in below to access your courses.
Log In With Google
Forgot Password
Enter your email address or username and we’ll send you instructions to reset your password.