Skip

6 posts tagged with sql by odinsdream.
Displaying 1 through 6 of 6.

Training courses for MCSA?

Please recommend training courses for certifications related to Microsoft server and SQL administration, such as MCSA. [more inside]
posted by odinsdream on Apr 4, 2013 - 2 answers

Best practices for MSSQL off-site backup?

What's the smartest way to keep regular backups of Microsoft SQL Server databases stored remotely? [more inside]
posted by odinsdream on Aug 6, 2011 - 2 answers

SQL - Accurately show how many rows an UPDATE statement is going to affect before execution.

SQL - How to get an accurate count of the rows potentially affected by an UPDATE statement, or best practices for performing updates? [more inside]
posted by odinsdream on Feb 9, 2010 - 18 answers

How can I import a 46GB database into MSSQL without ending up with a 46GB transaction log?

I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? [more inside]
posted by odinsdream on May 29, 2008 - 4 answers

SQL query to get unique addresses from a list.

Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label. [more inside]
posted by odinsdream on Apr 18, 2007 - 9 answers

SQL: Virtual Grouping?

SQL: Virtual Grouping? [more inside]
posted by odinsdream on Dec 13, 2005 - 9 answers

Page: 1
Posts