Forum Replies Created

Viewing 15 posts - 16 through 30 (of 70 total)

  • RE: The Reading Poll

    Aaron N. Cutshall (7/24/2009)

    Terri (7/24/2009)

    We can do just that now with audiobooks at our library. That is, I can go on line and "check out" an audiobook. The...

    July 24, 2009 at 11:51 am

    #1029940

  • RE: The Reading Poll

    Aaron N. Cutshall (7/24/2009)

    Several years ago I entered an essay contest at our local library about what I envisioned the library of the future to be. Basically, I envisioned...

    July 24, 2009 at 11:39 am

    #1029929

  • RE: The Reading Poll

    Well, i have not been counting but maybe I read 30-40 books a year, mostly fiction. I will read 4-5 books on vacation or travel, but it will...

    July 24, 2009 at 7:24 am

    #1029656

  • RE: free text search

    ajaykshanker (7/22/2009)

    Terri, Thanks a lot for the code sample. I updated the query based on your sample. It is working great and I dont have to worry about SQL injection....

    July 22, 2009 at 1:02 pm

    #1028619

  • RE: free text search

    In our web application we can search for a User by a portion of the name or logonid as follows

    SELECT UserSID

    ,LoginID

    ...

    July 21, 2009 at 8:44 am

    #1027673

  • RE: CHARINDEX in reverse

    andrewd.smith (7/1/2009)

    REVERSE is one of the less performant string functions in TSQL, so this alternative expression calls REVERSE only once.

    SELECT RIGHT(@nam, CHARINDEX(' ', REVERSE(@nam)) - 1)

    Bear in mind that this...

    July 6, 2009 at 10:12 am

    #1020490

  • RE: charindex help

    Good explanation Jeff. A small point, your solution fails if there is more than 1 space between the 2 words. e.g 'Lincoln Lincoln' has length 16. So...

    June 10, 2009 at 9:14 am

    #1007475

  • RE: Trigger interfering with application - how to avoid?

    We have triggers that update audit tables. In order to avoid the problem your are describing we do not use an identity column in the audit table. Instead...

    June 5, 2009 at 7:03 am

    #1005216

  • RE: Dead Data

    When I give up a machine at work I either wipe the hard drive myself or give it to the tech support group to wipe the hard drive to remove...

    May 28, 2009 at 6:39 am

    #1001349

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    I had one Fortran course as an undergrad and one PL/I in grad school. I got a Ph.D. in Math and taught at university for 10 years, first math,...

    May 5, 2009 at 7:33 am

    #988781

  • RE: Open Source Pay

    I work for state government for the past 25 years and salaries are a matter of public record. I could go to the library and look them up but...

    January 16, 2009 at 9:00 am

    #928244

  • RE: Image is Everything

    mhaskins (1/9/2009)

    I worked many years for an automation company. I wore a skirt once, and was asked - what are you going to do if you have to crawl into...

    January 9, 2009 at 9:01 am

    #924278

  • RE: Function that finds Sundays

    andrewd.smith (11/24/2008)

    SELECT DATEADD(DAY, DATEDIFF(DAY, '19000101', GETDATE()) / 7 * 7, '19000101') AS followingMonday,

    DATEADD(DAY, DATEDIFF(DAY, '19000101',...

    November 24, 2008 at 9:16 am

    #902566

  • RE: Problem with decryption

    GilaMonster (11/6/2008)

    Sure they can. Encryption is not designed to protect the mdf file (secure your server), not is it mean to protect against the DBA (If you don't trust your...

    November 7, 2008 at 7:03 am

    #895511

  • RE: Grouping records

    Adam Bean (10/7/2008)

    Hey Terri, any thoughts on how to add some better logic in by randomizing the deptname a little better to avoid same deptname groups (teams)?

    Thanks

    Well, it IS random...

    October 8, 2008 at 10:09 am

    #882429

Viewing 15 posts - 16 through 30 (of 70 total)