Looking for work? Check out our jobs area.

SQL Server DBA FAQs and Tips

Theme Graphic
Theme Graphic

SQL Server

SQL Server DBA FAQs and Tips This is a collection of FAQ and tips for SQL Server DBA and developers. The clear answers and sample...

Subscribe

Author

Archive

Tags

Posted on Wednesday, October 17, 2007 at 9:43 AM

SQL Server DBA FAQs and Tips

SQL Server DBA FAQs and Tips - 442 Questions/Tutorials http://dba.fyicenter.com/faq/sql_server/

Downloading and Installing SQL Server 2005 Express Edition (14 questions) http://dba.fyicenter.com/faq/sql_server/SQL_Server_2005_Express_Edition_Download_Installation.html

Getting Started with Transact-SQL Statements (10 questions) http://dba.fyicenter.com/faq/sql_server/Getting_Started_with_Transact-SQL_Statements.html

Creating and Managing Databases and Physical Files (16 questions) http://dba.fyicenter.com/faq/sql_server/Creating_and_Managing_Databases_and_Physical_Files.html

Creating/Managing Tables and Adding/Altering/Deleting Columns (16 questions) http://dba.fyicenter.com/faq/sql_server/Creating_Managing_Tables_and_Adding_Altering_Deleting_Columns.html

Understanding INSERT, UPDATE and DELETE Statements (18 questions) http://dba.fyicenter.com/faq/sql_server/Understanding_INSERT_UPDATE_DELETE_Statements.html

Understanding SELECT Statements with Joins and Subqueries (17 questions) http://dba.fyicenter.com/faq/sql_server/Understanding_SELECT_Statements_with_Joins_Subqueries.html Understanding SELECT Statements and GROUP BY Clauses (20 questions) http://dba.fyicenter.com/faq/sql_server/Understanding_SELETE_Statements_GROUP_BY_Clauses.html

Introduction To Transact-SQL Language Basics and Data Types (19 questions) http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Basics_and_Data_Types.html

Transact-SQL Constants/Literals and Value Ranges (18 questions) http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Constants_Literals_Value_Ranges.html

Transact-SQL Numeric Expressions and Functions (14 questions) http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Numeric_Expressions_and_Functions.html

Transact-SQL Managing Character Strings and Binary Strings (14 questions) http://dba.fyicenter.com/faq/sql_server/ransact-SQL_Managing_Character_and_Binary_Strings.html

Downloading and Installing Sample Scripts and Databases (6 questions) http://dba.fyicenter.com/faq/sql_server/Downloading_and_Installing_Sample_Scripts_and_Databases.html

SQL Server FAQs - Transact-SQL Date and Time Operations and Functions http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Date_and_Operations_and_Functions.html

SQL Server FAQs - Transact-SQL Boolean Values and Logical Operations http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Boolean_Values_and_Logical_Operations.html

SQL Server FAQs - Understanding and Managing Views http://dba.fyicenter.com/faq/sql_server/Understanding_and_Managing_Views.html

SQL Server FAQs - Transact-SQL Conditional Statements and Loops http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Conditional_Statements_and_Loops.html

SQL Server FAQs - Understanding and Managing Indexes http://dba.fyicenter.com/faq/sql_server/Understanding_and_Managing_Indexes.html

SQL Server FAQs - Transact-SQL Understanding Stored Procedures http://dba.fyicenter.com/faq/sql_server_2/Transact-SQL_Understanding_Stored_Procedures.html

SQL Server FAQs - Transact-SQL Understanding User_Defined_Functions http://dba.fyicenter.com/faq/sql_server_2/Transact-SQL_Understanding_User_Defined_Functions.html

SQL Server FAQs - Creating and Managing Schemas http://dba.fyicenter.com/faq/sql_server_2/Creating_and_Managing_Schemas.html

SQL Server FAQs - Security - Server Login and Database User http://dba.fyicenter.com/faq/sql_server_2/Security_Server_Login_Database_User.html

SQL Server FAQs - Configuring ODBC Connection and DSN for SQL Servers http://dba.fyicenter.com/faq/sql_server_2/Configuring_ODBC_Connection_and_DSN.html

SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution http://dba.fyicenter.com/faq/sql_server_2/PHP_ODBC_Connection_and_Query_Execution.html

SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows http://dba.fyicenter.com/faq/sql_server_2/PHP_ODBC_Managing_Tables_and_Data_Rows.html

SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution http://dba.fyicenter.com/faq/sql_server_2/PHP_MSSQL_Connection_and_Query_Execution.html

SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows http://dba.fyicenter.com/faq/sql_server_2/PHP_MSSQL_Managing_Tables_and_Data_Rows.html

SQL Server FAQs - Introduction to Triggers http://dba.fyicenter.com/faq/sql_server_2/Introduction_to_Triggers.html

SQL Server FAQs - Introduction to Cursors http://dba.fyicenter.com/faq/sql_server_2/Introduction_to_Cursors.html

SQL Server FAQs - Introduction to NULL Values http://dba.fyicenter.com/faq/sql_server_2/Introduction_to_NULL_Values.html
Bookmark: Submit To Digg Submit To reddit Submit To del.icio.us Bookmark With StumbleUpon Bookmark With FaceBook Bookmark With Google Bookmarks

0 comments on "SQL Server DBA FAQs and Tips"
No comments posted yet.

Leave A Comment
Subject:


Comment:
   Bold Italic Underline          Code Link Image Horizontal Rule


Because you do not have or are not logged in to your Programmer's Heaven account, please enter your name.

Name:


To help prevent comment SPAM, please enter the magic code '525' in the box:




Posting Rules
Please follow these rules when posting comments on blog posts.
  • Do not post anything that is racist, hate speech or of a sexual or adult nature.
  • Do not post or link to anything that infringes copyrighted laws.
  • Posting about security or legal topics is fine so long as you are not glorifying or encouraging people to perform illegal activities.
  • Both the author of this blog and the Programmer's Heaven administrators may delete any inappropriate comments without notice at their own discretion.
 
corner
© 1996-2008. All rights reserved. Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Publisher: Lars Hagelin.
bootstrapLabs Logo A bootstrapLabs project.