Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 3,221 total)

  • RE: Study material\dumps for Exam 70-450

    1. If you do not know how to use Goggle to find "braindumps", I doubt if and when you find one, you will be able to understand it, or...

  • RE: Convert string to datetime

    Provided that EDT is NOT required this is one way, and for a million rows it will NOT be quick.

    DECLARE @T VARCHAR(20)

    SET @T = 'July 7 2011 12:47 pm EDT'

    SET...

  • RE: Restoring Features

    paul s-306273

    Way back in the beginning, to make the site more attractive to those interested in Microsoft's SQL Server the founders decided to award points to the site users....

  • RE: Career Advice

    Become a member of PASS, find a local SQL Server user group

    http://www.sqlpass.org/PASSChapters/USNortheast.aspx

    Attend the meetings, introduce your self to other attending. In our user group frequent meeting sponsor(s) are consulting...

  • RE: delete without commit

    You can, but remember the old irish saying "There is many a slip between the cup and the lip"

    Set up a test database or sandbox as I call it

    Test your...

  • RE: run sprocs with date

    Here is another method to add 1 year and 1 day as the OP requested

    DECLARE @EndDate VARCHAR(10)

    DECLARE @StartDate VARCHAR(12)

    SET @EndDate = '07/15/2011'

    SET @StartDate = DATEADD(DD,1,DATEADD(YY,1,(CAST(@EndDate AS DATETIME))))

    SELECT CONVERT(DATETIME,@StartDate,101)...

  • RE: Query to calculate Turnaround Time

    I wrote a query that gives me all the cases from a single room and a single day, but I'm struggling how to identify the "previous" case end time.

    ...

  • RE: Did you notice SSC has passed the 1,400,000 members mark

    Did not notice until looking through the Forums and seeing this post of yours. While I agree it is a fantastic number of members, I also wonder how many...

  • RE: NUMA

    The source cited has the following statement:

    Nodes are created per physical NUMA memory nodes

    But, as it always is, how does one determine the number of soft NUMA nodes?

    Anyone.

  • RE: Article about server slowness/failures/showdowns

    An immediate source - In the left pane of an SSC page click on Books. Scroll through the list and you will find at least two available in...

  • RE: We Need a DBA Boot Camp

    1. Yes U.S. Army 1955 - during what was called the Korean Police Action, and received a 2nd Lts salary.

    2. I believe it would be an excellent idea...

  • RE: Rookie DBA

    Now this in NOT a quick technique to find a job, but something you might / should investigate for the longer term. Locate your nearest local chapter of...

  • RE: Cloud Barriers

    Jeff, gotcha beat on that dropping the cards - always sequence punched the cards in what (memory failing me) in columns 72 - 80. Then when I did drop...

  • RE: Cloud Barriers

    Jeff Moden

    None of these restrictions or limitations are new to us old farts. The only real difference that I can see between the Cloud and an old IBM Mainframe is...

Viewing 15 posts - 1,111 through 1,125 (of 3,221 total)