Forum Replies Created

Viewing 15 posts - 3,826 through 3,840 (of 19,560 total)

  • RE: OS Disk Capacity Information

    Jeff Moden (2/7/2014)

    wak_no1 (2/6/2014)

    Bob, thank you, this is working as I'd hoped. I can sort of see what I needed to do.

    One thing has just occurred to me though, I...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2014 at 8:08 am

    #1687078

  • RE: Server Migration

    With the plans to move to 2008 right away, I don't think I would chase this too far. It sounds most like a "feature" with 2000. I haven't...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2014 at 8:03 am

    #1687074

  • RE: T-SQL script to automatically restore the transaction logs?

    MyDoggieJessie (2/7/2014)

    Just so you know, it's kind of dangerous to be using queries like this if you're not sure what they actually do (just saying). This being said, the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2014 at 7:56 am

    #1687068

  • RE: T-SQL script to automatically restore the transaction logs?

    Currently that script is looking for the data to be first

    SUBSTRING (Col1, 1, 20)

    Your backup file format has the date much later in the file name. You will want...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 10:05 pm

    #1686903

  • RE: T-SQL script to automatically restore the transaction logs?

    What is the exact script you are using?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 9:55 pm

    #1686900

  • RE: T-SQL script to automatically restore the transaction logs?

    krishna.vijayawada (2/6/2014)

    HI,

    I am in need of a script. Which have to pick the latest LSN with sequence automatically and restore it "XXXDB" in no recovery mode. can any one help...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 9:49 pm

    #1686898

  • RE: Oddball Interview Questions

    I have had interviewers ask me these questions.

    I have also asked these types of questions. I ask it to try and get the candidate to divulge a little bit...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 9:46 pm

    #1686896

  • RE: Error backing up to network share

    I agree with the change to use the UNC instead of a mapped drive.

    Are you running SSMS as the agent service account (i see you RDP'd to the box using...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 9:12 pm

    #1686891

  • RE: Difference in Collations?

    You can try SQL_Latin1_General. It is reported to show as Latin1_General_CP1_CI_AI after installation.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 9:04 pm

    #1686890

  • RE: Syntax Error with Multi-Table Joins

    timSF (2/6/2014)

    Well, of course I knew that. (not!) Thanks for your very timely help!

    Well you were close and did a fine job of posting your exact problem.

    Those who answer questions...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 9:00 pm

    #1686889

  • RE: Job to delete folders older than X days old ?

    homebrew01 (2/6/2014)

    I run this as a SQL scheduled job on my Windows 2003 server:

    [font="Courier New"]ForFiles /P D:\objectscripts /D -180 /C "CMD /C if @ISDIR==TRUE echo RD /Q /S @FILE...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 8:56 pm

    #1686888

  • RE: Sending a Variable Number of Elements in a Parameter

    Jeff Moden (2/6/2014)

    What would be interesting now is to have a couple of drag races between your very much improved XML method, the UDTT method identified in this article, and...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 8:52 pm

    #1686887

  • RE: Duration for large table compression

    Your best bet is to try that in Dev first.

    While compression is great, I have seen it cause significant slowdowns in queries on very large tables (over 1TB).

    I'd also evaluate...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 7:02 pm

    #1686874

  • RE: Are criteria applied in order?

    Yes that could in some cases be the most efficient means of getting the script to run properly.

    But...that is not always the case.

    You really can't determine that until you fully...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 6:39 pm

    #1686872

  • RE: High CPU with many DB connections Prod almost down

    Ok, it's not a terrible thing that they don't have clustered PKs.

    Do they have any clustered indexes in the database at all?

    You mentioned that the app has to be restarted...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 6:35 pm

    #1686870

Viewing 15 posts - 3,826 through 3,840 (of 19,560 total)