Database tutorials
SQL2000 – Find Database Language
Contributed by katy8439 on under DatabaseHow to find the system language of a server running SQL2000 using a SQL statement.
CommentsSQL Server 2005: Move tempdb
Contributed by shamanstears on under DatabaseBy default, tempdb is placed on the same drive that SQL Server is installed on. This is probably not a desirable result, especially if you have installed SQL Server on the boot drive or on an IDE versus a SATA drive. To move tempdb to a faster drive and improve performance, follow these steps:
CommentsSQL Server 2005: Easily Grant Select to All Tables and/or Views in a Database
Contributed by shamanstears on April 24, 2007 under DatabaseGranting Select to all tables for a login can be an extremely painful and lengthy process. Utilizing the SQL Server Management Studio to perform this means going table by table and checking the Select checkbox for each individual table, this makes a real nightmare if you are working with hundreds of tables. You can do this in mere seconds versus hours by using the Query window. Here’s how:
CommentsMySQL: Increment an exisitng value
Contributed by qmchenry on February 24, 2007 under MySQLThis slick MySQL syntax allows you to increment or decrement an existing number in a table without first having to read the value. This is a nice way to increment an access counter.
CommentsSQL Server 2005: The Copy Database Wizard
Contributed by shamanstears on February 8, 2007 under DatabaseThe Copy Database Wizard is a very valuable asset when you are wanting to copy or move a database and its objects to another server. To utilize this functionality…
CommentsSQL Server 2005: How To Restore a Database from a Backup
Contributed by shamanstears on February 7, 2007 under DatabaseYour database is down, your users are in a panic, what do you do?. If you have been performing routine backups of your database, you can restore it to the point of the most recent backup. To restore your database, follow these steps:
CommentsSQL Server 2005: How To Perform a Full Backup of a Database
Contributed by shamanstears on under DatabaseA full backup includes database files and locations as well as parts of the transaction log. A full backup is necessary, regardless of the backup strategy that is implemented, because all other backup types (differential and transaction log) depend on the having a full backup. To perform a full backup of your database, follow these steps:
CommentsPOPULAR RECIPES
- SQL Server 2005: How To Restore a Database from a Backup
- SQL Server 2005: Move tempdb
- SQL Server 2005: Easily Grant Select to All Tables and/or Views in a Database
- SQL Server 2005: How to Attach (or Reattach) a Database Missing the LDF
- SQL Server 2005: The Copy Database Wizard
- Delete an LDAP object using ldapmodify
- SQL 2000 - Find version and service pack info
- SQL Server 2005: What Service Pack is Installed?
- View our Top Tens
TECH-RECIPES BLOGS
- you're doing it wrong! (rant)
- thoughts of a launch psp owner (post 4 1/2 years)
- Facebook FishVille Cheat: Send Multiple Free Gifts to Your Neighbors
- post release: Windows 7, homegroups and me
- fall 2009 and some geek thoughts, reflections
- Facebook Cafe World Cheat: Close Your Cafe When You are Away for Long Periods of Time (to preserve your Buzz Rating)
- Facebook Cafe World Cheat: Serve Your Customers Instantly
- Facebook Cafe World Cheat: Send Multiple Free Gifts to Your Neighbors








