Forum Replies Created

Viewing 15 posts - 61 through 75 (of 3,221 total)

  • RE: Command to execute Copy,Delete etc instead of XP_cmdShell

    You might want to read this

    http://www.sqlservercentral.com/Forums/Topic1173815-392-1.aspx#bm1173927

    and determine if the use of !! to execute operating system commands will work in your environment.

    If you do test ... please post your result...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    September 17, 2013 at 10:36 am

    #1650854

  • RE: New dba

    Ed Wagner -

    I know, practicing is not fun or exciting, but you don't want your first recovery to be when you need it and the boss is breathing down your...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    September 17, 2013 at 7:49 am

    #1650798

  • RE: Finding gaps within date ranges

    I suggest that you read this article by Jeff Moden

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

    For an excellent article including sample data and the code that will do what you seem to asking how to...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    September 13, 2013 at 12:21 pm

    #1650143

  • RE: Bug? when paging through author's article list

    Same problem with other authors .... for example Phil Factor and Guest Columnist: Larry Gonick

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    September 13, 2013 at 9:23 am

    #1650077

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/10/2013)

    SQLRNNR (9/10/2013)

    Brandie Tarvin (9/10/2013)

    I am seriously thinking of making DBCC Timewarp settings one of my own interview questions, just to see how far the SQL Conspiracy has spread....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    September 10, 2013 at 9:08 am

    #1648935

  • RE: Behavior of trigger

    Now I known why I detest using triggers.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    September 9, 2013 at 8:50 pm

    #1648699

  • RE: CTE

    You might want to start by reading this:

    http://www.4guysfromrolla.com/webtech/071906-1.shtml

    and then if you have specific questions ask those questions in a new posting.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    September 7, 2013 at 6:51 am

    #1648325

  • RE: Tally Tables

    Thanks for a nice question - good way to start a work week

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    September 2, 2013 at 8:28 pm

    #1646843

  • RE: Return

    Koen Verbeeck (8/18/2013)

    Nice one, thanks.

    +1

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 18, 2013 at 8:25 pm

    #1642534

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/15/2013)

    I'm prepping a table, which has gotten kind of large, for partitioning. While I've found some workarounds for it, it seems bloody incredible to me that you...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 15, 2013 at 8:41 pm

    #1641972

  • RE: 4-4-5 Calendar Creation Table in SQL Server

    I believe you will find what you are searching for in these two older articles here on SSC.

    http://www.sqlservercentral.com/articles/function/67046/

    http://www.sqlservercentral.com/articles/function/68323/

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 15, 2013 at 3:29 pm

    #1641939

  • RE: Identify string or integer

    I would suggest using ISNUMERIC, however it has several disadvantages that can lead one to a false conclusion.

    I would suggest that you read the following article by Jeff Moden to...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 14, 2013 at 7:10 am

    #1641372

  • RE: Temp db if full

    Read the following:

    http://msdn.microsoft.com/en-us/library/windows/desktop/ms675048(v=vs.85).aspx

    It lists what you can do and how to do it .....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 13, 2013 at 10:37 am

    #1641043

  • RE: _WA unused stats

    This worked for me using SQL Server 2000, have not used in a later version.

    Give it a try and then come back and post if it worked or...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 11, 2013 at 2:43 pm

    #1640429

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/9/2013)

    A car actually lasted for 276,000 miles??? That's impressive. I've heard of some holder Honda models making it to the low 200's, but nothing that high

    For all the...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 9, 2013 at 3:37 pm

    #1640305

Viewing 15 posts - 61 through 75 (of 3,221 total)