Forum Replies Created

Viewing 15 posts - 766 through 780 (of 3,221 total)

  • RE: Encryption

    NIce question - and non controversial so much better than reindeer

    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]

    December 27, 2011 at 8:51 pm

    #1425926

  • RE: Are the posted questions getting worse?

    Revenant

    I can be biased, but I would make sure that the methodology conforms to http://www.amazon.com/How-We-Test-Software-Microsoft/dp/0735624259/ref=sr_1_1?ie=UTF8&qid=1324952533&sr=8-1.

    Gosh - if that is the definitive method then Lord help us all....

    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]

    December 26, 2011 at 8:39 pm

    #1425551

  • RE: Documentation

    In addition to the obvious items you have listed, I would as a start list:

    1. Major purpose of server.

    a. Mirror sever for .......

    ...

    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]

    December 26, 2011 at 4:21 pm

    #1425542

  • RE: Are the posted questions getting worse?

    Jeff Moden (12/26/2011)

    Thanks for the feedback. Yeah, I know. I sound like a real wire-head trying to explain why I didn't want to publish such a thing and...

    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]

    December 26, 2011 at 12:47 pm

    #1425526

  • RE: Find out the Database Actual Size and used size ???

    Is this the information you are seeking?

    CREATE PROCEDURE [dbo].[DBSize_TableSpace_Used]

    AS

    -- Author: Michael Valentine Jones

    -- Script to analyze table space usage using the

    -- output from the sp_spaceused stored procedure

    -- Works with...

    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]

    December 26, 2011 at 10:44 am

    #1425520

  • RE: Are the posted questions getting worse?

    Since I also previously asked all of you good folks to not publish an article on the rapid generation of test data, I have to ask... do any of 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]

    December 26, 2011 at 10:12 am

    #1425515

  • RE: Group by in Stored procedure

    When using dynamic sql, and depending upon how it is entered (from a web application / interface only available to a trusted few employees), you should be aware of 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]

    December 25, 2011 at 7:11 pm

    #1425448

  • RE: Christmas Fun

    SQL Kiwi (12/25/2011)

    Interesting - I cheated, obviously, and found there are nine, but it appears eight is also right:

    http://en.wikipedia.org/wiki/Santa_Claus%27s_reindeer

    Add to the above

    http://www.battlecreekenquirer.com/article/20111225/OPINION02/112250319

    in late 1939, when the original story of Rudolph...

    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]

    December 25, 2011 at 8:30 am

    #1425428

  • RE: Are the posted questions getting worse?

    Lowell your posting of this link to assist an OP

    TallyCalendar_Complete_With_DST.txt

    Lowell -Fantastic amount of work - from a IT standpoint thanks for sharing - Glad you were willing to play...

    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]

    December 24, 2011 at 5:44 pm

    #1425385

  • RE: quick way to create a table that has every day of the year in it?

    Lowell (12/16/2011)

    here's a copy of mine named TallyCalendar, which generates dates from the SQL beginning of time (1900-0101) to 100 years in the future compared to today.

    the advantage is i've...

    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]

    December 24, 2011 at 5:37 pm

    #1425384

  • RE: Last day of Month

    Here is a series of T-SQL statements for getting various dates, you will probably find what you want here

    http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

    Also suggest you add these to your "Sandbox" DB for future...

    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]

    December 23, 2011 at 1:35 pm

    #1425277

  • RE: Happy Holidays

    paul.goldstraw (12/23/2011)

    I got the answer right but only based on the American-centric nature of previous questions. A question for the Americans here though; if Reindeer is the logical answer and...

    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]

    December 23, 2011 at 12:41 pm

    #1425266

  • RE: Loop through all databases

    This article on an undocumented procedure might assist you

    http://www.sqlservercentral.com/articles/Advanced+Querying/sp_msforeachdb/182/

    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]

    December 23, 2011 at 12:21 pm

    #1425261

  • RE: All I want for Christmas

    In a lighter mode ... "All I want for Christmas is my two front teeth"

    http://www.youtube.com/watch?v=_ZreIZ5EAQU

    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]

    December 23, 2011 at 10:31 am

    #1425230

  • RE: If your employer stops paying for your cert

    lkokeunda (12/22/2011)

    Jeff Moden (12/22/2011)

    lkokeunda (12/22/2011)

    My boss got her boss to pay for my one SQL server cert, but is ignoring my request for financially supporting my further cert endeavor (study...

    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]

    December 22, 2011 at 8:21 pm

    #1425011

Viewing 15 posts - 766 through 780 (of 3,221 total)