Forum Replies Created

Viewing 15 posts - 16,726 through 16,740 (of 26,489 total)

  • RE: How many of you have done Certification for SQL Server?

    greg-877697 (3/3/2010)

    I've been a SQL DBA since 1998, never taken a certification test. My resume speaks for my qualifications, not a test of theoretical knowledge that many people memorise...

    March 3, 2010 at 8:57 am

    #1127856

  • RE: How many rows are returned from the query below?

    honza.mf (3/3/2010)

    Lynn Pettis (3/3/2010)

    And I'm sorry if you don't like assumptions, do you work with users that always tell you everything you need need the first time? Must be...

    March 3, 2010 at 7:43 am

    #1127772

  • RE: How many of you have done Certification for SQL Server?

    I would like to get the certs, just haven't had the time.

    My desire to get them is more for validation of my own knowledge, but it would be nice to...

    March 3, 2010 at 7:22 am

    #1127755

  • RE: How many rows are returned from the query below?

    Fatal Exception Error (3/3/2010)

    bitbucket-25253 (3/3/2010)

    Fatal Exception Error

    I think part of his point is that versions were not specified which is fairly important.

    Disagree. If you are attempting to...

    March 3, 2010 at 7:06 am

    #1127746

  • RE: How many rows are returned from the query below?

    honza.mf (3/3/2010)

    Lynn Pettis (3/3/2010)

    Second, it doesn't matter how many rows are in the table tblUsers (unless it only contained one row, but everyone so far has assumed more than one),...

    March 3, 2010 at 7:03 am

    #1127743

  • RE: How many rows are returned from the query below?

    Toreador (3/3/2010)

    Lynn Pettis (3/3/2010)

    Second, it doesn't matter how many rows are in the table tblUsers (unless it only contained one row, but everyone so far has assumed more than one),...

    March 3, 2010 at 6:54 am

    #1127733

  • RE: TRICKY SQL QUERY

    martin.edward (3/3/2010)

    Dear Experts ,

    I would like to do the following :-

    get the date out of a certain column in a table

    select docdate from tablename

    Check if the docdate is...

    March 3, 2010 at 6:49 am

    #1127729

  • RE: IS SQL SERVER 2005 SUPPORT INCREMENTAL BACKUP

    vbprogrammer1986 (3/3/2010)

    I Want a Backup copy of that portion of data which is change since last any type of backup(full or differential).what is the name of this type backup? may...

    March 3, 2010 at 6:46 am

    #1127726

  • RE: How many rows are returned from the query below?

    I don't agree that the question was poorly written, just poorly read.

    First, it is obvious that this question was directed to SQL Server 2005/2008 because of the CTE. CTE's...

    March 3, 2010 at 6:35 am

    #1127716

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/2/2010)

    Chris Morris-439714 (3/2/2010)

    "How about them Bears?" 🙂

    Is it just me, or are the posters who appear to be the students, the ones who have the nerve to post...

    March 2, 2010 at 1:32 pm

    #1127391

  • RE: Can't figure out why DBCC CHECKDB is running

    mike mcneer (3/2/2010)

    I would setup a profiler trace.. add additional columns such as hostname,ip,login and then the standard stuff and filter the trace to only pickup that domain admin account...

    March 2, 2010 at 12:51 pm

    #1127357

  • RE: Avoid dynamic SQL

    Rob Schripsema (3/2/2010)

    Lynn,

    Wow. Very cool, very clever....but with all of the SUBSTRINGing, CHARINDEXing and concatenating going on, is this really more efficient than a simple while loop? (Oh dear, I...

    March 2, 2010 at 11:42 am

    #1127317

  • RE: Problem in join update

    Julie Breutzmann (3/2/2010)

    The Dixie Flatline (3/1/2010)

    Keith,

    To handle concatenation of nulls, you need use either the ISNULL() or COALESCE() function. .

    I recommend that you use COALESCE. ISNULL is also...

    March 2, 2010 at 11:20 am

    #1127305

  • RE: Avoid dynamic SQL

    Rob Schripsema (3/2/2010)

    I do know that SSRS passes field(parameter?) lists as a string of comma-separated values. That doesn't require dynamic SQL or even a cursor/while loop to split it...

    March 2, 2010 at 11:16 am

    #1127301

  • RE: table scan problem

    Tara-1044200 (3/2/2010)

    Create Table #Daterange

    (

    start_d datetime,

    end_d datetime,

    )

    begin

    Insert into #Daterange

    Values

    ('02/12/2003','12/03/2009')

    end

    select distinct a.empnumber, filldate,empcode

    into #tmp_calc

    from Vwrevenue as a inner join #revdates as b on a.empnumber = b.empnumber, #daterange

    where filldate between start_d and end_d

    Above...

    March 2, 2010 at 10:55 am

    #1127285

Viewing 15 posts - 16,726 through 16,740 (of 26,489 total)