“SQL and Database Management Systems” has 82 entries.
- Explicit Join Syntax and Implicit Join Syntax
- “Why do you create a View in a database?”
- “SQL Server 2000 Sample Databases”; Northwind and pubs
- SQL Server CLR: “Regular Expressions in MS SQL Server 2005/2008”; CodeProject.com
- SQL Server 2008: “Minimize SQL Server 2008 Surface Area”
- SQL Server 2008 SSRS: “All those temporary files (RSTempFiles)”; John Gallardo, MSDN
- SQL Server 2005: “Understanding "login failed" (Error 18456) error messages”
- SQL Server 2005/2008: “SQL Server UPDATE STATISTICS”
- SQL Server: “How to shrink the tempdb database in SQL Server”
- SQL Server 2005: Summary of DBCC Commands; Emil Chang
- SQLite: Recommended Management Tools for Ubuntu Linux; GUIs
- SQL Server: “An Introduction to Clustered and Non-Clustered Index Data Structures” by G. Vijayakumar
- The Differences between a Clustered and Non-clustered Index
- SQL Server 2005 PROBLEM: “Unable to determine if the owner (DOMAIN\xxx) of job
has server access (reason: error code 0x534. [SQLSTATE 42000] (Error 15404))”; Andrew Calvett - SQL Server Express: “SQL Server Express and Hosting”
- Microsoft SQL Server 2005/2000 Compatibility Problem: SQL 2005 CREATE TABLE Syntax Fails in SQL 2000
- SQL Server 2005 t-SQL: The Use of the nodes() Method for SQL Types; Converting XML Data into SQL Types
- SQL Server 2000: DTS; “Package Ownership Issues”; http://www.sqldts.com/212.aspx
- SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; insert text; XML Data Modification Language (DML)
- SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; insert text; replace value of; XML Data Modification Language (DML)
- SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; insert element; XML Data Modification Language (DML)
- SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; delete; XML Data Modification Language (DML)
- SQL Server 2005 t-SQL: The Use of the nodes() Method for XML Types
- SQL Server 2005 t-SQL: Flippant Remarks about Using XPath Assertions Instead of XML Schema
- SQL Server 2005 t-SQL: Basic XQuery Example
- T-SQL: Stored Procedure Structure for Microsoft SQL Server 7.0/2000; Command Names Pattern
- T-SQL: Stored Procedure Structure for Microsoft SQL Server 6.5
- T-SQL Code: Example of Connecting to Index Server and Listing Files in Scope
- SQL: When to Use Dynamic SQL and When to Use Stored Procedures; Views and SELECT Stored Procedures
- T-SQL Code: Stored Procedure AutoDTS_complianceDumps; An Example of Running a DTS Package in tSQL
- T-SQL: Stored Procedure Structure for Microsoft SQL Server 7.0
- SQL Server 2005: Flippant Remarks about the New FOR XML PATH() Syntax
- SQL Server 2005 t-SQL: Linking an Orphaned Database User to a Server Login
- T-SQL Code: A Function for Checking for the Existence of an Object; fItemExists()
- T-SQL: User-Defined Function Structure; Table/Set Form
- T-SQL: User-Defined Function Structure; Scalar Form
- SQL Server 2005 PROBLEM: Using the ADO.NET DbCommand.ExecuteScalar() Method Truncates at 2033 Characters
- SQL Server 2005 t-SQL: Bulk Insert Operation
- SQL Server 2000: CONVERT() Style Identifiers
- SQL Server 2000: UTC datetime values; GETUTCDATE()
- T-SQL Code: Date Format User-Defined Function; dbo.fDateFormat()
- SQL Server 2000: Flippant Remarks about Mixed Mode; Security; Authentication
- DTS ActiveX Script Task: Assigning SQL Statements to Execute SQL Tasks Based on Global Variables
- tSQL Code: Example of OPENROWSET with Trusted Connection; NTLM
- SQL Server 2000: Flippant Remarks about Renaming Databases
- T-SQL Code: Adding/Refreshing Login and User Metadata; CreateUsers.sql; Troubleshooting Orphaned Users
- SQL Server 2000 Data Transformation Services; Flippant Remarks about the DTS Data Driven Query Task; Updating Data with DTS
- MySQL Adminstration: mysqldump Help Text;mysqldump Ver 9.11 Distrib 4.0.21; Win95/Win98 (i32); Igor Romanenko, Monty, Jani & Sinisa
- DTS: Fixed-Role Permissions for Logins to Change Data in SQL Server 2000; Data Transformation Services; db_ddladmin
- T-SQL Syntax: The LIKE Operator with Bracket Wildcard Operators ([]); Using Wildcard Characters as Literals
- DTS ActiveX Script Task: Formatting an Apache Log File; Visual Basic ActiveX Script; Data Transformation Services
- T-SQL Code: Correlated Sub-Queries in the SELECT Projection List
- T-SQL: Flippant Remarks about Table Aliases and the Self Join
- SQL Server 2000: Flippant Remarks about Designing for Portability
- MS SQL Server 7.x: Tables sysxlogins and sysservers
- MS SQL Server 7.x: When to Use Views; Normalized Data
- T-SQL: Dynamic SQL in a Stored Procedure; sp_executesql
- T-SQL: Using OPENROWSET to Join Server Data with File-based Data
- SQL Server 7.x and VB 6.x Code: Manipulating Data Transformation Services (DTS) Programmatically
- T-SQL Code: DELETEing Duplicates
- T-SQL Code: Searching for a Finite Set of Unknowns with a Single SELECT Statement; the ISNULL() Function
- T-SQL Code: Example of the use of a Cursor; Parsing WebCom Hit Log Files; NewHitLog
- T-SQL Code: Another Example of the use of a Cursor; Parsing WebCom Hit Log Files; GetHitsImport
- T-SQL: Renaming a Table Containing Data; Saving/Restoring Data from a Dropped Table; SELECT INTO
- SQL: SELECTing Duplicates
- PL/SQL: Oracle 7; Date Arithmetic with SYSDATE
- SQL: The Differences Beteween HAVING and WHERE
- T-SQL Code: A Procedure Using CASE Structures to Format Times
- SQL: The Difference between UNION and UNION ALL
- SQL: Domain Aggregate Record Sets Are Not Updatable
- Denormalization; SQL 7.x OLAP and Data Cubes
- SQL: AND and OR Operate on True, False and Null
- From SQL Server 7 to Oracle 7: Remarks
- ODBC SQL: The Syntax for Stored Procedure Execution
- T-SQL: Implicit Descision Structures Using substring(), sign() and charindex(); the Sybase isnull() System Function
- T-SQL: Notes on the Outer Join
- T-SQL: Values Stored in Sybase/Microsoft Sysobjects Table
- MS-SQL and T-SQL: Deleting Records Not in Another Table
- T-SQL: DELETEing Rows Based on a Date Column; Use of DATEADD() And GETDATE()
- T-SQL: Measuring How Long a Query Takes
- Notes on SQL Server Standards and Guidelines
- MS SQL Server 6.5: ISQL/w Can Connect to Sybase Databases