Forum Replies Created

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

  • RE: Changing setting for first day of the week

    Also I don't know which language you are using, however you can change the language for the user like:

    Check the language that has the first date Monday... more correct check...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Changing setting for first day of the week

    Did you try:

    SET DATEFIRST 1;

    GO

    Check the first date with

    SELECT @@DATEFIRST

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: MCSA & MCSE SQL Server 2012 !?

    Yep!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Authentication Mode

    Did you check if your account is locked in Active Directory, just in case!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: How to split Delimited text

    Jeff, you are amazing how you are playing with T-SQL!

    In every code that you have published for any solution, I have learned something new!

    Thank you sir!

    Dugi

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: index rebuild no effect

    Take a look to the sweet tool from RedGate that is still free to use and let us know what happened!

    http://www.red-gate.com/products/dba/sql-index-manager/[/url]

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: SQL server 2008 Build List

    Seems that we need to update the list so seriously, Steve make someone Admin for incoming updates of the SQL Server!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: SQL Server 2008 R2 running very slowly after Hardware upgrade

    Seems, time for the consultancy or reading and searching lot of stuff about Performance ...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: URGENT,how to get the definition of a procedure.

    Hmm and something when you are working with critical things on critical environment, is when you need to change something, just duplicate in this case you SP and rename it...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: URGENT,how to get the definition of a procedure.

    Try this if you can find something in the Query Column:

    SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query]

    FROM sys.dm_exec_query_stats AS deqs

    CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest

    ORDER BY deqs.last_execution_time DESC

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Jeff Moden elected Exceptional DBA of 2011

    Congratulations Jeff - I knew that you deserve it and you will win ! :w00t:

    So thank you from community point for your help to the SQL Community!

    ~ Dugi

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Hidden RBAR: Counting with Recursive CTE's

    Jeff Moden (8/9/2011)


    Dugi (8/9/2011)


    Jeff,

    Thanks for the very nice stuff! Simple to say that I need to read it again and doing more and more practicing and practicing ...!

    Have a nice...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Hidden RBAR: Counting with Recursive CTE's

    Jeff,

    Thanks for the very nice stuff! Simple to say that I need to read it again and doing more and more practicing and practicing ...!

    Have a nice day,

    Dugi

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Update multiple rows using Sub Query

    Ninja's_RGR'us (5/13/2011)


    Dugi (5/13/2011)


    stan-617410 (5/13/2011)


    Thank you...

    Ninja's_RGR'us, you are right... I have a trigger, I didn't realize that it was having the problem.

    Thanks Dugi, your last submission is where I...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Update multiple rows using Sub Query

    stan-617410 (5/13/2011)


    Thank you...

    Ninja's_RGR'us, you are right... I have a trigger, I didn't realize that it was having the problem.

    Thanks Dugi, your last submission is where I started.

    I appreciate...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

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