absolute cobblers

Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Wednesday, 27 August 2008

How to de-dupe a record set using a temporary table (MSSQL)

›
Following on from the SQL Fire we witnessed a while ago I've just wrote this rather snazzy little query that does something similar. The...
Saturday, 2 August 2008

Saturday Morning: Website Security Time...

›
Recently a couple of our sites have been subject to SQL Injection Attacks but non have suffered so hard as the one I'm currently securin...
Tuesday, 26 February 2008

Shrinking Log files in SQL Server 2005

›
So you, like I, have a database in SQL Server 2005 who's log file (.ldf) has grown massive. Here is a quick but of SQL that should help ...
Wednesday, 13 February 2008

SQL Noise

›
Someone's going to be annoyed when they end up here looking for how to add "noise" to an SQL query.. oh well, sorry... However...
1 comment:

SQL : Multiple Order By's

›
Just trying to sort a query with an ORDER BY clause where I needed to order by two columns in different directions so I tried it and it work...
78 comments:
›
Home
View web version
Powered by Blogger.