Database tutorials

SQL Server 2005/2008: Disable Management Studio’s Splash Screen

contributed by Rob Rogers on October 12, 2008 under Database

If you have grown tired of having to view the splash screen each and every time you open the SQL Server Management Studio, you can use a simple command line switch in your shortcut to bypass the annoyance.

 

Microsoft SQL Server: How to Find the Foreign Keys in a Database

contributed by Rob Rogers on October 4, 2008 under Database

A foreign key is a column or columns that are used to enforce a link between data in two tables. While SQL Server gives you no quick and easy way to view all foreign keys in a database, this quick query will give you that information. It comes in handy when trying to troubleshoot Foreign Key Constraint errors.

 

SQL Server 2005: How to Disable a Trigger

contributed by Rob Rogers on September 26, 2008 under Database

A trigger allows for the execution of SQL code anytime an UPDATE, INSERT, or DELETE command is performed on a certain table. If you are having to perform manual modifications to the table, you may not want the trigger to fire off. Here’s how to disable the trigger so that you can perform your administrative tasks:

 

SQL Server 2005: What Service Pack is Installed?

contributed by Rob Rogers on January 7, 2008 under Database

If you’re running SQL Server, it’s very wise to make sure that you have the latest service pack installed for optimum performance. If you’re not sure what service pack you have installed (or if you’re still running RTM), follow these steps to find out:

 

Import CSV file directly into MySQL

contributed by katy8439 on May 8, 2007 under MySQL

Instead of writing a script to pull in information from a CSV file, you can link MYSQL directly to it and upload the information using the following SQL syntax.

 

SQL 2000 – Find version and service pack info

contributed by katy8439 on under Database

Run the following code in SQL Server 2000 Query Analyzer to return the Version and Service pack – useful if you’re having problems on a server and don’t know if you’re running the latest patches or not.

 

SQL Server 2000 – Find Database Language

contributed by katy8439 on under Database

How to find the system language of a server running SQL Server 2000 using a SQL statement.

 

SQL Server 2005: Move tempdb

contributed by Rob Rogers on under Database

By 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: