Forum Replies Created

Viewing 15 posts - 151 through 165 (of 716 total)

  • RE: Filtered Indexes

    PHYData DBA (4/22/2015)

    Hany Helmy (4/22/2015)

    Realy don`t understand why can`t we use "Not In" for a filtered index while we can use "In" operator?! :w00t:

    Only simple comparisons work.

    NOT + <any...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 22, 2015 at 11:35 pm

    #1792922

  • RE: Filtered Indexes

    Realy don`t understand why can`t we use "Not In" for a filtered index while we can use "In" operator?! :w00t:

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 22, 2015 at 3:33 am

    #1792651

  • RE: NONclustered 2 clustered

    Very nice question, had to test it before answering 😉

    And the shortcut 4 exec sp_help dsa is highlight the table and press Alt + F1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 19, 2015 at 12:03 am

    #1791843

  • RE: ISNULL vs COALESCE

    Aleksl-294755 (4/17/2015)

    Great and helpful question. I didn't know that. Thanks!

    + 1, I am not using COALESCE much lately.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 18, 2015 at 11:44 pm

    #1791842

  • RE: Deterministic

    Interesting question, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 16, 2015 at 2:40 am

    #1791261

  • RE: Using LAG

    [Using XML in Computed Columns], hmmm, that`s somthin new. Thanx

    This is 4 the Computed Column question, don`t know how it came here :hehe::cool:

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 15, 2015 at 7:01 am

    #1791081

  • RE: Delete Windows Service

    Ok good to know that, thanx.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 15, 2015 at 6:54 am

    #1791079

  • RE: How to compress the data transfer during synchronisation between availability group nodes?

    From http://www.sqlserverspecialists.com/2013/02/log-stream-compression-sql-server-2008.html:

    [With SQL Server 2008 (I think the same applies to 2012), the log stream is compressed by default. To measure the impact of log compression, we used the trace...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 15, 2015 at 2:47 am

    #1791013

  • RE: Temp Table Names

    SQLRNNR (4/10/2015)

    Great explanation. Because BOL said so. :hehe::hehe:

    :-D:-D

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 12, 2015 at 12:03 am

    #1790376

  • RE: Temp Table Names

    peter.row (4/10/2015)

    The script in the answer fails because of the following:

    select @a, @b, @c

    As @c is not declared (nor is it used elsewhere in the script).

    It has been corrected to...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 12, 2015 at 12:01 am

    #1790375

  • RE: Legal/illegal characters in table name

    Stewart "Arturius" Campbell (4/8/2015)

    Good question, despite the tmp schema "issue"

    Highlights the difference between what is possible and what is practical.

    True, this is possible but not practical @ all, who will...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 8, 2015 at 2:21 am

    #1789454

  • RE: Legal/illegal characters in table name

    MyDoggieJessie (4/7/2015)

    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    +1, this should have been mentioned in the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 8, 2015 at 2:17 am

    #1789453

  • RE: BULK INSERT first row

    I don`t remember loading a flat file into a SQL table since long time, so it`s good to know a new stuff 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 8, 2015 at 1:53 am

    #1789442

  • RE: DBCC shrinkfile error - Msg 8985

    GilaMonster (5/24/2013)

    Please note: 9 year old thread.

    Now it`s even 11 years old thread, but amazingly still very useful to fix the current issues, seems that MS will never ran out...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 5, 2015 at 5:56 am

    #1788801

  • RE: DBCC shrinkfile error - Msg 8985

    Nicholas Cain (4/14/2004)

    Try shrinking it using the fileid (SELECT NAME, FILEID FROM SYSFILES), use the same syntax, just replace the filename with the fileid.

    Just want 2 thank u cause that...

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

    April 5, 2015 at 5:54 am

    #1788800

Viewing 15 posts - 151 through 165 (of 716 total)