http://www.sqlservertoolkit.com SQL Server Toolkit is the best SQL Server website out there. Sat, 21 Nov 2009 02:36:00 +0000 http://backend.userland.com/rss092 en Sometimes, you might need to get a record set of the UNION of two SELECT's but you don't want to remove duplicates.  This might happen if you were just needing a proper count of the rows or if you just wanted to check something before deleting a bunch of rows. The ... http://www.sqlservertoolkit.com/uncategorized/sql-union-all-vs-union/ There will be times when 2 people are trying to change the same record at the same time.  For example, a Human Resources Manager might want to change an Employee's salary and an IT person might want to update the Employee's password.  This is not an uncommon problem and applications ... http://www.sqlservertoolkit.com/sql-tips-and-tricks/using-timestamp-datatype-to-reduce-database-corruption/ In a recent project, we had to deal with SQL Server transactions that involved multiple timezones and required us to calculate the time employee's worked across a 24x7 retail chain.  Every time someone clocked-in or clocked-out we recorded the current time so we could later calculate the hours worked.  The ... http://www.sqlservertoolkit.com/sql-tips-and-tricks/getutcdate-vs-getdate-with-timezones-and-daylight-savings/ While working with SQL Server, I Often find myself needing to just change 1 value in a database record on a production server.  Usually, this happens after working with SQL Query Analzyer to research a problem and then realize that I can't select the resulting rows below to fix the ... http://www.sqlservertoolkit.com/sql-tips-and-tricks/using-sql-server-managment-studio-sql-icon-to-update-records/ We regularly get questions about what is the best way to replicate or mirror SQL Server databases to protect against disaster and to provide high availability.  There are many options out there and there is no right answer, but I thought I would address 2 we have used (SQL Server Database ... http://www.sqlservertoolkit.com/sql-server-database/sql-server-database-mirroring-vs-double-take/ A common problem you run across in SQL programming is the need to group a series of records that contain bit fields and you need to determine the appropriate value.  If you were to try it using the MAX/MIN operators to achieve the equivalent AND/OR result of the bit field or even ... http://www.sqlservertoolkit.com/sql-tips-and-tricks/sql-aggregate-bit-columns-with-group-by/