Category Archives: SQL

Structured Query Language, is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon relational algebra and calculus. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control. SQL was one of the first commercial languages for Edgar F. Codd’s relational model, as described in his influential 1970 paper, “A Relational Model of Data for Large Shared Data Banks”. Despite not adhering to the relational model as described by Codd, it became the most widely used database language

Use INFORMATION_SCHEMA to find data about your database

Posted on 02/21/2011 by Eric Fickes

Have you ever been in this situation?  You’re the new developer for a database powered application and you have to figure out what tables contain a specific column?  Or maybe you’ve got a legacy database that needs it’s stored procedures … Continue reading →

Posted in database, development, internets, SQL | Tagged , , , , , , , , , , , , , | 1 Comment

An aggregate may not appear in the set list of an UPDATE statement

Posted on 02/20/2011 by Eric Fickes

Ever seen the error “An aggregate may not appear in the set list of an UPDATE statement” when working with SQL Server?  I ran into this one recently after trying to put a COUNT in an UPDATE statement.  I was rewriting … Continue reading →

Posted in database, development, internets, microsoft, SQL, tips and tricks, tsql | Leave a comment

Today I took 30 minutes to save hours

Posted on 01/03/2011 by Eric Fickes

UPDATE – 1/6/2011 : Since writing this post I have bundled this entire reset process into a single windows batch file. In addition to restoring my database, I also have to remove temp files from my server, so it was … Continue reading →

Posted in database, development, SQL, tips and tricks | Tagged , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Use sys.dm_exec_sessions to disconnect SQL user connections

Posted on 01/03/2011 by Eric Fickes

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 — init vars DECLARE … Continue reading →

Posted in database, internets, microsoft, SQL, tsql | Leave a comment