Forum Replies Created

Viewing 7 posts - 46 through 53 (of 53 total)

  • RE: Examine Data Values to Determine Data Type of Column

    I have the same issue, but mine doesn't stem from a flat file it comes from an XML document which doesn't have any data typing...(even if it did it would...


    Over 12yrs in IT and 10yrs happily stuck with SQL.
    - SQL 2008/R2/2012/2014/2016/2017
    - Oracle 8/9/10/11
    - MySQL 4/5 and MariaDB

  • RE: Twenty tips to write a good stored procedure

    Hi All,

    I don't post a lot but I do read almost all of the articles posted here. When I first started out doing SQL, I had some of these...


    Over 12yrs in IT and 10yrs happily stuck with SQL.
    - SQL 2008/R2/2012/2014/2016/2017
    - Oracle 8/9/10/11
    - MySQL 4/5 and MariaDB

  • RE: Super Quick Table Meta Data

    Please see the above attached 2005 friendly script...


    Over 12yrs in IT and 10yrs happily stuck with SQL.
    - SQL 2008/R2/2012/2014/2016/2017
    - Oracle 8/9/10/11
    - MySQL 4/5 and MariaDB

  • RE: Super Quick Table Meta Data

    You know a feature that would be neat to add, if you left the table empty or put in a %, and then typed in a column name... Then return...


    Over 12yrs in IT and 10yrs happily stuck with SQL.
    - SQL 2008/R2/2012/2014/2016/2017
    - Oracle 8/9/10/11
    - MySQL 4/5 and MariaDB

  • RE: XML Workshop XVII - Writing a LOOP to process XML elements in TSQL

    This example really spelled out what I should do, and the discussions showed other ways of achieving the same thing.

    I find the documentation in BOL sufficient but the lack of...


    Over 12yrs in IT and 10yrs happily stuck with SQL.
    - SQL 2008/R2/2012/2014/2016/2017
    - Oracle 8/9/10/11
    - MySQL 4/5 and MariaDB

  • RE: Moving Large Table to Different File Group

    I have actually found if you split the tables into multiple files it will decrease the time it takes to have a table grow. I also have noticed a flaw...


    Over 12yrs in IT and 10yrs happily stuck with SQL.
    - SQL 2008/R2/2012/2014/2016/2017
    - Oracle 8/9/10/11
    - MySQL 4/5 and MariaDB

  • RE: Performance Information using T-SQL

    I found a small issue with this report

    the procedure [MS_PerfDashboard].[usp_Main_GetSessionInfo] needs to be updated as the maximum time in milliseconds a datediff can process is 24 days, 20 hours, 31...


    Over 12yrs in IT and 10yrs happily stuck with SQL.
    - SQL 2008/R2/2012/2014/2016/2017
    - Oracle 8/9/10/11
    - MySQL 4/5 and MariaDB

Viewing 7 posts - 46 through 53 (of 53 total)