Forum Replies Created

Viewing 15 posts - 1 through 15 (of 31 total)

  • RE: Indexes, Indexes, Indexes

    BW_Toro (7/8/2011)


    Where is the author? Where are the folks who defended the data collection query as harmless?

    Steven993 said the query is fine. I think I have shown it's not fine.

    Brian...

  • RE: Indexes, Indexes, Indexes

    BW_Toro (7/6/2011)


    I think the query as highlighted is an accurate representation. The effect of the problem is more than simply listing an index more than once, it can list an...

  • RE: Indexes, Indexes, Indexes

    Have to ask whats Alice's Restaurant??

  • RE: Indexes, Indexes, Indexes

    BW_Toro (7/6/2011)


    Why is there not more concern being expressed when the query cited by peter-757102 (see page 1) is probably causing incorrect results from this tool? I posted a related...

  • RE: Indexes, Indexes, Indexes

    doranmackay (7/5/2011)


    For me it was quick to find the root cause.

    So when you have stuff like "where [datetimecolumn] >=getdate()" (if datetimecolumn is indexed)

    the optimizer says "You know what, range...

  • RE: Creating Login SQL Express 2008

    Where is the express instance installed, on you local machine or on a server somewhere? is it a named instance or default? what are you using to connect to it?

  • RE: opening SSIS package for edit

    Take a copy of the package from your source control system (which everyone always does :-D) and use BIDS (business intelligence development studio, part of the SQL Server client tools)....

  • RE: Indexes, Indexes, Indexes

    tom.groszko (7/5/2011)


    The presense of an index is not necessarly a problem even if the index is not used. In your article you failed to state what problem you were trying...

  • RE: Table constraints

    Hi

    I doubt the inability to update this table has anything to do with the check constraint (if it has been dropped). What exception message do you get when you try...

  • RE: Table constraints

    mfayard (9/13/2010)


    I am trying to update records in a table that had a check constraint to set the table to read only. That constraint was removed (dropped) and it...

  • RE: SQL 2008 SSIS FTP Connection through Firewall

    I'm guessing here and it may be nothing, but could you have added the 32 bit version of DTExec to the firewall rules?

  • RE: *****Table Structure and Data ******

    Hi Nari

    I'm not really sure what your asking, but I think you might just need to back up XYZ and restore as XYZ_MOCK

  • RE: Print Column names vertically from table

    One problem with using Information_Schema and catalog views is that the user executing the query must have access to the object(s) being referenced.

  • RE: sql

    I thought I should update due to an error posted.

    The assertion that the datetime data type rounds up by 3.33 ms is incorrect. After some research on this datatype I...

  • RE: SQL Instance checkings.

    gareth.thompson (8/30/2010)


    Its not for a monitoring purpose.

    What I am doing is a tracking of every database of their online status and database sizes and growth of the instances.

    Its not continually...

Viewing 15 posts - 1 through 15 (of 31 total)