Re: Very slow distinct select

Rich (no@xxxxxxxxxxxx) writes:
> What the heck is DDL???
> Didn't I give enough info in my two posts?
> And what does the name matter?

DDL = Data Definition Laguage. That is CREATE TABLE etc. Which it appears
that you did include.

Too many SQL savvies just throw this funny TLAs(*) around them, and
don't give a damn if people they pretend to help understand them or not.


(*) TLA = Three-letter abbriviation.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.

Relevant Pages

  • Re: Why Oracle does not allow rollback of DDL statements?
    ... DDL statements are executed. ... does allow rollback of DDL statements if I am not mistaken. ... concept of transaction where by a group of statements can be rolled ... When I started learning SQL Server, ...
    (comp.databases.oracle.server)
  • Re: Why Oracle does not allow rollback of DDL statements?
    ... DDL statements are executed. ... does allow rollback of DDL statements if I am not mistaken. ... There are many legitimate reasons you want to have transaction ddl, ... When I started learning SQL Server, ...
    (comp.databases.oracle.server)
  • busy with another hstmt - Error
    ... I am running SQL 2k on Win 2k Server. ... [ODBC SQL Server Driver]Connection is busy with ... ' Open From ACH Processing recordset ... DDL tblACH_Proc: ...
    (microsoft.public.sqlserver.programming)
  • Re: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY
    ... It will save you even more time if you simply provide the DDL for BOTH ... Columnist, SQL Server Professional ... help explain why I cannot delete and recreate constraints in a sp or script ... > "Tom Moreau" wrote: ...
    (microsoft.public.sqlserver.server)
  • Descending index is not supported in the SQL/Sybase server
    ... The only problem I've run into when trying to generate DDL from a model is ... I am thinking that Visio is generating SQL Server 7.0 syntax and not SQL ... to know whether SQL 7.0 allowed descending indexes or not. ...
    (microsoft.public.visio.general)