Forum Replies Created

Viewing 15 posts - 31 through 45 (of 789 total)

  • RE: FREE! SQL Scripts Manager – a Christmas gift from Red Gate

    robertm-772679 (12/23/2010)

    I must be doing something wrong. I downloaded the scriptsmanager.zip file from the link but when I try to extract the scripts there are no files present in the...

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

    December 23, 2010 at 6:25 am

    #1265887

  • RE: FREE! SQL Scripts Manager – a Christmas gift from Red Gate

    Very nice free tool, nice stuff inside, thanks from the authors and RedGate!

    :hehe::w00t::hehe::w00t::hehe:

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

    December 23, 2010 at 3:10 am

    #1265833

  • RE: GetDate() or CURRENT_TIMESTAMP

    Jeff Moden (12/17/2010)

    Heh... I use GETDATE() for several reasons but these are my favorites... It has fewer characters to type, I've used it forever, I don't believe in the myth...

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

    December 21, 2010 at 3:42 am

    #1264981

  • RE: GetDate() or CURRENT_TIMESTAMP

    WayneS (12/16/2010)

    I think Microsoft prefers getdate().

    CREATE TABLE #test (RowID INT IDENTITY, MyDate DATETIME DEFAULT (CURRENT_TIMESTAMP));

    SELECT definition

    FROM tempdb.sys.default_constraints

    WHERE parent_object_id = object_id('tempdb..#test');

    returns:

    definition

    -----------

    (getdate())

    Interesting Info Wayne! - However, I'm using...

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

    December 21, 2010 at 3:38 am

    #1264980

  • RE: sort only database table

    I agree with Gila here, but seems that you want to see just the tables per database, if you want something like that, you can check with simple query:

    SELECT NAME,...

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

    December 18, 2010 at 2:58 pm

    #1264401

  • RE: Grant Fritchey

    crystal8es (12/2/2010)

    I am a newbie here and just wanna say Hi to everyone. I am Crystal from Louisiana, US.

    Welcome on board, have a nice stay!

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

    December 2, 2010 at 11:54 pm

    #1258228

  • RE: SSIS -> Excel, large data sets

    Alvin Ramard (10/28/2010)

    I'll take this one.

    Have you done with this, I want to read your article !?

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

    November 26, 2010 at 6:10 pm

    #1255922

  • RE: SUMs when joining one to many tables

    Yes I see, but you are doing the brilliant and perfect comparison and explanation using the current solutions!

    Have a nice weekend buddy!

    Greetings!

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

    November 26, 2010 at 12:58 pm

    #1255884

  • RE: SUMs when joining one to many tables

    Jeff you are amazing, buddy... T-SQL simple works for you, really!

    :w00t::hehe::cool:;-)

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

    November 26, 2010 at 12:33 pm

    #1255874

  • RE: Remote Connection 2008 R2 not allowed

    Take a look here http://is.gd/hO85W for you problem, follow the steps and tell us if you find the solution!

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

    November 26, 2010 at 1:00 am

    #1255718

  • RE: Remote Connection 2008 R2 not allowed

    Be sure that your TCP is enabled in both side, you and your friend's SQL Server, enabling TCP will allow you to use remote connection!

    However be sure that you have...

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

    November 26, 2010 at 12:38 am

    #1255710

  • RE: Sorting Months By Number (SQL Spackle)

    sdorris-1150234 (11/15/2010)

    All I can say is that when Jeff talks, I tend to listen. Thanks for the post, Jeff.

    I vote for this ... Jeff, thanks for the nice article!

    :hehe:

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

    November 15, 2010 at 2:29 pm

    #1250998

  • RE: Do you have an idea an Oracle Instance on Windows 2008 R2 Cluster?

    without any problem we can discuss also for Oracle vs SQL Server, sure the SSC is open to the database technology community, and it has the separate section for the...

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

    November 10, 2010 at 1:24 pm

    #1249142

  • RE: SQL to Oracle & ViceVersa

    DNA_DBA (11/1/2010)

    There's a document here that shows how the two databases compare from a DBA point of view:

    http://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/SQLServer2008forOracle.docx

    It's not so bad working with both once you work out how to...

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

    November 2, 2010 at 1:26 am

    #1245218

  • RE: Can not Kill SPID

    Try to check sys.dm_exec_requests !?

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

    October 25, 2010 at 3:17 am

    #1241459

Viewing 15 posts - 31 through 45 (of 789 total)