DBA KB: SQL Servers Topic

Learn how to make an easy SQL Server Script that will automatically back up all your databases in a simple way.

In this article, you will be shown a few generic methods to optimize your SQL queries.  This information is not database-specific (other than in a few places) and should apply to any SQL based database.

Think globally, act locally.  How many times have you needed to determine the geographic distance between two places?  This tutorial will show you how to accomplish just that.

All data and functions exist in a SQL Server Database, and can be used in VB.NET, C#.NET, Paradox, Delphi, or any other language that can call a database function.

Need to grant EXECUTE permission to a low-permission user for all the Stored Procedures in your database?

The code in this article will do the trick for you.

In MS-SQL, to move an object such as a table or view from one schema to another, use alter schema.

The installation of the SourceGear Vault client control appears to trash SQL Server Management Studio and Visual Studio.

Here's the fix that worked for me.

Error: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code -2146885628.

The Solution: Opened the "properties" dialog for the service, and on the Log On tab, changed the user from "This Account" to "Local System Account".  Started the service, and bingo.