http://www.programmersheaven.com/user/karl_vi/blog/ Contains the latest posts from the blog 'SQL Server' Thu, 04 Dec 2008 11:15:20 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification http://www.programmersheaven.com/user/karl_vi/blog/35-SQL-Server-DBA-FAQs-and-Tips/ SQL Server DBA FAQs and Tips - 442 Questions/Tutorials<br /> <a href="http://dba.fyicenter.com/faq/sql_server/">http://dba.fyicenter.com/faq/sql_server/</a><br /> <br /> Downloading and Installing SQL Server 2005 Express Edition (14 questions) <br /> <a href="http://dba.fyicenter.com/faq/sql_server/SQL_Server_2005_Express_Edition_Download_Installation.html">http://dba.fyicenter.com/faq/sql_server/SQL_Server_2005_Express_Edition_Download_Installation.html</a><br /> <br /> Getting Started with Transact-SQL Statements (10 questions)<br /> <a href="http://dba.fyicenter.com/faq/sql_server/Getting_Started_with_Transact-SQL_Statements.html">http://dba.fyicenter.com/faq/sql_server/Getting_Started_with_Transact-SQL_Statements.html</a> <br /> <br /> Creating and Managing Databases and Physical Files (16 questions) <br /> <a href="http://dba.fyicenter.com/faq/sql_server/Creating_and_Managing_Databases_and_Physical_Files.html">http://dba.fyicenter.com/faq/sql_server/Creating_and_Managing_Databases_and_Physical_Files.html</a><br /> <br /> Creating/Managing Tables and Adding/Altering/Deleting Columns (16 questions) <br /> <a href="http://dba.fyicenter.com/faq/sql_server/Creating_Managing_Tables_and_Adding_Altering_Deleting_Columns.html">http://dba.fyicenter.com/faq/sql_server/Creating_Managing_Tables_and_Adding_Altering_Deleting_Columns.html</a><br /> <br /> Understanding INSERT, UPDATE and DELETE Statements (18 questions) <br /> <a href="http://dba.fyicenter.com/faq/sql_server/Understanding_INSERT_UPDATE_DELETE_Statements.html">http://dba.fyicenter.com/faq/sql_server/Understanding_INSERT_UPDATE_DELETE_Statements.html</a><br /> <br /> Understanding SELECT Statements with Joins and Subqueries (17 questions)<br /> <a href="http://dba.fyicenter.com/faq/sql_server/Understanding_SELECT_Statements_with_Joins_Subqueries.html">http://dba.fyicenter.com/faq/sql_server/Understanding_SELECT_Statements_with_Joins_Subqueries.html</a><br /> <br /> Understanding SELECT Statements and GROUP BY Clauses (20 questions) <br /> <a href="http://dba.fyicenter.com/faq/sql_server/Understanding_SELETE_Statements_GROUP_BY_Clauses.html">http://dba.fyicenter.com/faq/sql_server/Understanding_SELETE_Statements_GROUP_BY_Clauses.html</a><br /> <br /> Introduction To Transact-SQL Language Basics and Data Types (19 questions) <br /> <a href="http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Basics_and_Data_Types.html">http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Basics_and_Data_Types.html</a><br /> <br /> Transact-SQL Constants/Literals and Value Ranges (18 questions) <br /> <a href="http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Constants_Literals_Value_Ranges.html">http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Constants_Literals_Value_Ranges.html</a><br /> <br /> Transact-SQL Numeric Expressions and Functions (14 questions) <br /> <a href="http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Numeric_Expressions_and_Functions.html">http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Numeric_Expressions_and_Functions.html</a><br /> <br /> Transact-SQL Managing Character Strings and Binary Strings (14 questions) <br /> <a href="http://dba.fyicenter.com/faq/sql_server/ransact-SQL_Managing_Character_and_Binary_Strings.html">http://dba.fyicenter.com/faq/sql_server/ransact-SQL_Managing_Character_and_Binary_Strings.html</a><br /> <br /> Downloading and Installing Sample Scripts and Databases (6 questions)<br /> <a href="http://dba.fyicenter.com/faq/sql_server/Downloading_and_Installing_Sample_Scripts_and_Databases.html">http://dba.fyicenter.com/faq/sql_server/Downloading_and_Installing_Sample_Scripts_and_Databases.html</a> <br /> <br /> SQL Server FAQs - Transact-SQL Date and Time Operations and Functions<br /> <a href="http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Date_and_Operations_and_Functions.html">http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Date_and_Operations_and_Functions.html</a><br /> <br /> SQL Server FAQs - Transact-SQL Boolean Values and Logical Operations<br /> <a href="http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Boolean_Values_and_Logical_Operations.html">http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Boolean_Values_and_Logical_Operations.html</a><br /> <br /> SQL Server FAQs - Understanding and Managing Views<br /> <a href="http://dba.fyicenter.com/faq/sql_server/Understanding_and_Managing_Views.html">http://dba.fyicenter.com/faq/sql_server/Understanding_and_Managing_Views.html</a><br /> <br /> SQL Server FAQs - Transact-SQL Conditional Statements and Loops<br /> <a href="http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Conditional_Statements_and_Loops.html">http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Conditional_Statements_and_Loops.html</a><br /> <br /> SQL Server FAQs - Understanding and Managing Indexes<br /> <a href="http://dba.fyicenter.com/faq/sql_server/Understanding_and_Managing_Indexes.html">http://dba.fyicenter.com/faq/sql_server/Understanding_and_Managing_Indexes.html</a><br /> <br /> SQL Server FAQs - Transact-SQL Understanding Stored Procedures<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/Transact-SQL_Understanding_Stored_Procedures.html">http://dba.fyicenter.com/faq/sql_server_2/Transact-SQL_Understanding_Stored_Procedures.html</a><br /> <br /> SQL Server FAQs - Transact-SQL Understanding User_Defined_Functions<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/Transact-SQL_Understanding_User_Defined_Functions.html">http://dba.fyicenter.com/faq/sql_server_2/Transact-SQL_Understanding_User_Defined_Functions.html</a><br /> <br /> SQL Server FAQs - Creating and Managing Schemas<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/Creating_and_Managing_Schemas.html">http://dba.fyicenter.com/faq/sql_server_2/Creating_and_Managing_Schemas.html</a><br /> <br /> SQL Server FAQs - Security - Server Login and Database User<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/Security_Server_Login_Database_User.html">http://dba.fyicenter.com/faq/sql_server_2/Security_Server_Login_Database_User.html</a><br /> <br /> SQL Server FAQs - Configuring ODBC Connection and DSN for SQL Servers<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/Configuring_ODBC_Connection_and_DSN.html">http://dba.fyicenter.com/faq/sql_server_2/Configuring_ODBC_Connection_and_DSN.html</a><br /> <br /> SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/PHP_ODBC_Connection_and_Query_Execution.html">http://dba.fyicenter.com/faq/sql_server_2/PHP_ODBC_Connection_and_Query_Execution.html</a><br /> <br /> SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/PHP_ODBC_Managing_Tables_and_Data_Rows.html">http://dba.fyicenter.com/faq/sql_server_2/PHP_ODBC_Managing_Tables_and_Data_Rows.html</a><br /> <br /> SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/PHP_MSSQL_Connection_and_Query_Execution.html">http://dba.fyicenter.com/faq/sql_server_2/PHP_MSSQL_Connection_and_Query_Execution.html</a><br /> <br /> SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/PHP_MSSQL_Managing_Tables_and_Data_Rows.html">http://dba.fyicenter.com/faq/sql_server_2/PHP_MSSQL_Managing_Tables_and_Data_Rows.html</a><br /> <br /> SQL Server FAQs - Introduction to Triggers<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/Introduction_to_Triggers.html">http://dba.fyicenter.com/faq/sql_server_2/Introduction_to_Triggers.html</a> <br /> <br /> SQL Server FAQs - Introduction to Cursors<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/Introduction_to_Cursors.html">http://dba.fyicenter.com/faq/sql_server_2/Introduction_to_Cursors.html</a><br /> <br /> SQL Server FAQs - Introduction to NULL Values<br /> <a href="http://dba.fyicenter.com/faq/sql_server_2/Introduction_to_NULL_Values.html">http://dba.fyicenter.com/faq/sql_server_2/Introduction_to_NULL_Values.html</a> http://www.programmersheaven.com/user/karl_vi/blog/35-SQL-Server-DBA-FAQs-and-Tips/ Wed, 17 Oct 2007 09:43:45 -0700 karl_vi