IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE
   ► KBSQL Servers   Print This     

DBA KB: SQL Servers Topic


Topics

11 Articles Found in the SQL Servers Topic  (or one of the sub-topics in bold above)

  KB Article    

Mike Prestwood
1. Char vs NChar What is the differences between Char, NChar, VarChar, and NVarChar?
Posted to KB Topic: Microsoft SQL Server
9 years ago

FAQ
Nothing New Since Your Last Visit
13719
Hits

DBA, Databases, & Data

Bryan Valencia
2. Easy SQL Server Backup Script

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

Posted to KB Topic: Microsoft SQL Server
45 months ago
(1 Comments , last by Theessay.S )

Code

KB Post
Nothing New Since Your Last Visit
3660
Hits

DBA, Databases, & Data

Mike Prestwood
3. Edit SQL Views? Are views in Microsoft SQL Server editable?
Posted to KB Topic: Microsoft SQL Server
9 years ago

FAQ
Nothing New Since Your Last Visit
4773
Hits

DBA, Databases, & Data

Bryan Valencia
4. General SQL Optimization Tips

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.

7 years ago

KB Post
Nothing New Since Your Last Visit
4929
Hits

DBA, Databases, & Data

Bryan Valencia
5. Geolocation: Step by Step

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.

7 years ago, and updated 7 years ago
(3 Comments , last by mprestwood )

Article
Nothing New Since Your Last Visit
10723
Hits

DBA, Databases, & Data

Wes Peterson
6. Granting Execute Permissions for Stored Procedures

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.

Posted to KB Topic: Microsoft SQL Server
32 months ago
(2 Comments , last by mcalsky.m )

Article
Nothing New Since Your Last Visit
2162
Hits

DBA, Databases, & Data

Mike Prestwood
7. InterBase Standard Database Specifications Interbase database and field specifications
Posted to KB Topic: Interbase
15 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
5003
Hits

DBA, Databases, & Data

Mike Prestwood
8. Move Table to Another Schema

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

Posted to KB Topic: Microsoft SQL Server
8 years ago

Code
Nothing New Since Your Last Visit  
7971
Hits

DBA, Databases, & Data

Wes Peterson
9. SQL Server Nasty Crash - Vault?

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.

6 years ago

KB Post
Nothing New Since Your Last Visit
3462
Hits

DBA, Databases, & Data

Mike Prestwood
10. The Database Group http://www.dbginc.com/
Posted to KB Topic: Interbase
9 years ago

Link
Nothing New Since Your Last Visit
3515
Hits

DBA, Databases, & Data

Bryan Valencia
11. Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. ... service-specific error code -2146885628

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.

Posted to KB Topic: Microsoft SQL Server
7 years ago, and updated 6 years ago
(7 Comments , last by mprestwood )

Error
Nothing New Since Your Last Visit
29544
Hits

DBA, Databases, & Data

Icon Legend:
Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).

New DBA, Databases, & Data Knowledge Base Post...

Share your knowledge with the WORLD! In addition to adding comments to existing posts, you can post knowledge you've acquired. We welcome full articles (intro with screen shots), general posts (shorter), and tidbits (tips, FAQs, definitions, etc.).

Post New...

Tidbit Post: Short Flashcard FAQ Definition Quick Tip Code Snippet
Longer Post: Full Article General Post File Link Error News
Other: Blog Topic
Or, if YOU have a question...
  DBA, Databases, & Data Message Board
-
   Contact Us!
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


Go ahead!   Use Us! Call: 916-726-5675 


©1995-2017 Prestwood IT Solutions.   [Security & Privacy]