first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

“SQL and Database Management Systems” has 82 entries.

  1. Explicit Join Syntax and Implicit Join Syntax
  2. “Why do you create a View in a database?”
  3. “SQL Server 2000 Sample Databases”; Northwind and pubs
  4. SQL Server CLR: “Regular Expressions in MS SQL Server 2005/2008”; CodeProject.com
  5. SQL Server 2008: “Minimize SQL Server 2008 Surface Area”
  6. SQL Server 2008 SSRS: “All those temporary files (RSTempFiles)”; John Gallardo, MSDN
  7. SQL Server 2005: “Understanding "login failed" (Error 18456) error messages”
  8. SQL Server 2005/2008: “SQL Server UPDATE STATISTICS”
  9. SQL Server: “How to shrink the tempdb database in SQL Server”
  10. SQL Server 2005: Summary of DBCC Commands; Emil Chang
  11. SQLite: Recommended Management Tools for Ubuntu Linux; GUIs
  12. SQL Server: “An Introduction to Clustered and Non-Clustered Index Data Structures” by G. Vijayakumar
  13. The Differences between a Clustered and Non-clustered Index
  14. 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
  15. SQL Server Express: “SQL Server Express and Hosting”
  16. Microsoft SQL Server 2005/2000 Compatibility Problem: SQL 2005 CREATE TABLE Syntax Fails in SQL 2000
  17. SQL Server 2005 t-SQL: The Use of the nodes() Method for SQL Types; Converting XML Data into SQL Types
  18. SQL Server 2000: DTS; “Package Ownership Issues”; http://www.sqldts.com/212.aspx
  19. SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; insert text; XML Data Modification Language (DML)
  20. SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; insert text; replace value of; XML Data Modification Language (DML)
  21. SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; insert element; XML Data Modification Language (DML)
  22. SQL Server 2005 t-SQL: The Use of the modify() Method for XML Types; delete; XML Data Modification Language (DML)
  23. SQL Server 2005 t-SQL: The Use of the nodes() Method for XML Types
  24. SQL Server 2005 t-SQL: Flippant Remarks about Using XPath Assertions Instead of XML Schema
  25. SQL Server 2005 t-SQL: Basic XQuery Example
  26. T-SQL: Stored Procedure Structure for Microsoft SQL Server 7.0/2000; Command Names Pattern
  27. T-SQL: Stored Procedure Structure for Microsoft SQL Server 6.5
  28. T-SQL Code: Example of Connecting to Index Server and Listing Files in Scope
  29. SQL: When to Use Dynamic SQL and When to Use Stored Procedures; Views and SELECT Stored Procedures
  30. T-SQL Code: Stored Procedure AutoDTS_complianceDumps; An Example of Running a DTS Package in tSQL
  31. T-SQL: Stored Procedure Structure for Microsoft SQL Server 7.0
  32. SQL Server 2005: Flippant Remarks about the New FOR XML PATH() Syntax
  33. SQL Server 2005 t-SQL: Linking an Orphaned Database User to a Server Login
  34. T-SQL Code: A Function for Checking for the Existence of an Object; fItemExists()
  35. T-SQL: User-Defined Function Structure; Table/Set Form
  36. T-SQL: User-Defined Function Structure; Scalar Form
  37. SQL Server 2005 PROBLEM: Using the ADO.NET DbCommand.ExecuteScalar() Method Truncates at 2033 Characters
  38. SQL Server 2005 t-SQL: Bulk Insert Operation
  39. SQL Server 2000: CONVERT() Style Identifiers
  40. SQL Server 2000: UTC datetime values; GETUTCDATE()
  41. T-SQL Code: Date Format User-Defined Function; dbo.fDateFormat()
  42. SQL Server 2000: Flippant Remarks about Mixed Mode; Security; Authentication
  43. DTS ActiveX Script Task: Assigning SQL Statements to Execute SQL Tasks Based on Global Variables
  44. tSQL Code: Example of OPENROWSET with Trusted Connection; NTLM
  45. SQL Server 2000: Flippant Remarks about Renaming Databases
  46. T-SQL Code: Adding/Refreshing Login and User Metadata; CreateUsers.sql; Troubleshooting Orphaned Users
  47. SQL Server 2000 Data Transformation Services; Flippant Remarks about the DTS Data Driven Query Task; Updating Data with DTS
  48. MySQL Adminstration: mysqldump Help Text;mysqldump Ver 9.11 Distrib 4.0.21; Win95/Win98 (i32); Igor Romanenko, Monty, Jani & Sinisa
  49. DTS: Fixed-Role Permissions for Logins to Change Data in SQL Server 2000; Data Transformation Services; db_ddladmin
  50. T-SQL Syntax: The LIKE Operator with Bracket Wildcard Operators ([]); Using Wildcard Characters as Literals
  51. DTS ActiveX Script Task: Formatting an Apache Log File; Visual Basic ActiveX Script; Data Transformation Services
  52. T-SQL Code: Correlated Sub-Queries in the SELECT Projection List
  53. T-SQL: Flippant Remarks about Table Aliases and the Self Join
  54. SQL Server 2000: Flippant Remarks about Designing for Portability
  55. MS SQL Server 7.x: Tables sysxlogins and sysservers
  56. MS SQL Server 7.x: When to Use Views; Normalized Data
  57. T-SQL: Dynamic SQL in a Stored Procedure; sp_executesql
  58. T-SQL: Using OPENROWSET to Join Server Data with File-based Data
  59. SQL Server 7.x and VB 6.x Code: Manipulating Data Transformation Services (DTS) Programmatically
  60. T-SQL Code: DELETEing Duplicates
  61. T-SQL Code: Searching for a Finite Set of Unknowns with a Single SELECT Statement; the ISNULL() Function
  62. T-SQL Code: Example of the use of a Cursor; Parsing WebCom Hit Log Files; NewHitLog
  63. T-SQL Code: Another Example of the use of a Cursor; Parsing WebCom Hit Log Files; GetHitsImport
  64. T-SQL: Renaming a Table Containing Data; Saving/Restoring Data from a Dropped Table; SELECT INTO
  65. SQL: SELECTing Duplicates
  66. PL/SQL: Oracle 7; Date Arithmetic with SYSDATE
  67. SQL: The Differences Beteween HAVING and WHERE
  68. T-SQL Code: A Procedure Using CASE Structures to Format Times
  69. SQL: The Difference between UNION and UNION ALL
  70. SQL: Domain Aggregate Record Sets Are Not Updatable
  71. Denormalization; SQL 7.x OLAP and Data Cubes
  72. SQL: AND and OR Operate on True, False and Null
  73. From SQL Server 7 to Oracle 7: Remarks
  74. ODBC SQL: The Syntax for Stored Procedure Execution
  75. T-SQL: Implicit Descision Structures Using substring(), sign() and charindex(); the Sybase isnull() System Function
  76. T-SQL: Notes on the Outer Join
  77. T-SQL: Values Stored in Sybase/Microsoft Sysobjects Table
  78. MS-SQL and T-SQL: Deleting Records Not in Another Table
  79. T-SQL: DELETEing Rows Based on a Date Column; Use of DATEADD() And GETDATE()
  80. T-SQL: Measuring How Long a Query Takes
  81. Notes on SQL Server Standards and Guidelines
  82. MS SQL Server 6.5: ISQL/w Can Connect to Sybase Databases