Forum Replies Created

Viewing 15 posts - 1,321 through 1,335 (of 2,462 total)

  • RE: tempdb log space usage troubleshooting

    SQL Guy 1 (7/21/2015)

    Thanks a lot, Vincy. Checkpoint greatly helped me. I was running it just once, and it was enough to bring it to 0%, though it took...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 21, 2015 at 12:48 pm

    #1813947

  • RE: tempdb log space usage troubleshooting

    60% may not be big deal. You can keep an eye on it using DBCC SQLPERF(LOGSPACE).

    If you consistently see that the tempdb log is filling you will want to...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 21, 2015 at 11:41 am

    #1813924

  • RE: Table(s) design for messaging functionality

    You may want to consider adding a Subject field and an EmailChain ID field. Most applications that provide this type of functionality include a subject line. An EmailChain ID would...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 21, 2015 at 10:38 am

    #1813909

  • RE: table size difference in two DB

    mailtoashokberwal (7/20/2015)

    I am having an issue in determining the correct size of a table.

    I have a tableA in some DB on transaction server (Enterprise Edition), this table is being...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 21, 2015 at 10:27 am

    #1813907

  • RE: Can this be done?

    jonathanm 4432 (7/21/2015)

    Never used powershell. Is it something that is easily learned and can be done?

    Check out Stairway to Powershell[/url]

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 21, 2015 at 10:12 am

    #1813901

  • RE: Different characters on new SQL Server 2005 than previous SQL Server 2005 server?!

    WebTechie (7/21/2015)

    Hello,

    I recently migrated a production environment from a Windows 2003 server with SQL Server 2005 (SVPK 2). I migrated the environment to a Windows 2008 Server with SQL...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 21, 2015 at 10:06 am

    #1813900

  • RE: Indexes with more writes than reads

    lmarkum (7/17/2015)

    Alan,

    Thanks for the comments. If an index has 50 reads and 1 million writes, for example, then 99.9 of the usage of that index is spent on...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 17, 2015 at 10:37 pm

    #1813467

  • RE: Find the position of all occurrences of an expression within a string

    Steven Willis (4/19/2013)

    Jeff Moden (4/14/2013)

    Please consider using a Tally Table instead of a recursive CTE to count. Please see the following article as to why.

    http://www.sqlservercentral.com/articles/T-SQL/74118/

    Thanks for the suggestion Jeff....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 17, 2015 at 9:32 pm

    #1813465

  • RE: Indexes with more writes than reads

    The number of reads on some of these did give me pause, despite the out of balance ratio to writes.

    There's no reason (based on the information you have provided...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 17, 2015 at 7:13 pm

    #1813463

  • RE: Replication Issues

    Welsh Corgi (7/17/2015)

    Alan.B (7/16/2015)

    Is there a work around?

    If it's possible to index the view that would would be an option.

    That is not going to work.

    Thanks.

    That's bummer. I have never...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 17, 2015 at 5:31 pm

    #1813458

  • RE: Indexes with more writes than reads

    [Quote]In some cases there are a few hundred thousand

    reads but maybe a million writes on the index.[/quote]

    That's not the best way to determine if you should keep an index....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 17, 2015 at 2:51 pm

    #1813443

  • RE: UNION ALL performance issues - one table is NULL

    There's not enough information here to give you a definitive answer.

    Could you post:

    1. The DDL for both tables

    2. The query plan produced when you do a SELECT * from...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 17, 2015 at 2:25 pm

    #1813433

  • RE: PatReplace8K

    DonlSimpson (6/30/2015)

    Alan.B (6/30/2015)

    Based on my testing, the function appears to perform a bit faster using CHECKSUM over ROW_NUMBER() instead of the conversion to BIGINT in the TOP clause.

    http://www.sqlservercentral.com/Forums/Topic1585850-391-3.aspx

    So it...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 16, 2015 at 4:26 pm

    #1813143

  • RE: Replication Issues

    Is there a work around?

    If it's possible to index the view that would would be an option.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    July 16, 2015 at 4:16 pm

    #1813142

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/30/2015)

    Congrats Alan!!!

    What is that building in the background?

    Thank you sir. That's a Northwestern University building - I think it's the medical school but it could be the law...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 30, 2015 at 8:28 pm

    #1809356

Viewing 15 posts - 1,321 through 1,335 (of 2,462 total)