Forum Replies Created

Viewing 15 posts - 211 through 225 (of 322 total)

  • RE: Best Practices for Database Design

    A very nice article. Straight forward and practical advice. It's good to see these practices written about regularly, and I always like hearing the many various preferences that others express.

    My...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 21, 2008 at 10:06 am

    #832234

  • RE: A Private Database

    Views (filtered) have been used for years to implement row level security.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 9, 2008 at 8:38 am

    #826130

  • RE: The OUPUT Command

    vijay_download (11/1/2007)

    Hi,

    I m NOT using storedprocedure. I m using the ADO command object which will stored the compiled command text. I m passing only parameter value in UPDATE command text....

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 6, 2008 at 11:32 am

    #825615

  • RE: A Look At SQL Server Compact Edition

    Robert O'Connell (7/10/2007)

    The biggest downside to using SQL Server Compact Edition is that it does not allow the creation of stored procedures. This seems to be Access with a...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 6, 2008 at 8:29 am

    #825490

  • RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

    Jeff Moden (5/30/2008)

    Howdy folks,

    Someone who wishes to remain anonymous, send me an email asking the following questions related to this article. I've not worked with SQL Server 2008 (shoot,...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 31, 2008 at 1:49 pm

    #822659

  • RE: Datetime conversion

    Yes. 2 should have been an option. I would have gotten it wrong then instead of testing it to get it right.

    Nice QoD. We are destined to constantly forget the...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 23, 2008 at 2:32 pm

    #819917

  • RE: SQLServerCentral Friday Crossword No 2

    Interesting. It caught it coming and going(when i hit the Back button). It identified this one as Crossword1(1).htm.

    Funny thing is, I remember doing that puzzle when it came out, and...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 23, 2008 at 2:00 pm

    #819913

  • RE: SQLServerCentral Friday Crossword No 2

    Ravi,

    BitDefender didn't actually prevent the puzzle from loading and working. As far as I can tell, it just quarantined something that was traveling along with it.

    I know you from other...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 23, 2008 at 1:36 pm

    #819904

  • RE: SQLServerCentral Friday Crossword No 2

    What the???

    Virus Blocked Trojan.Script.2314!

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 23, 2008 at 1:08 pm

    #819896

  • RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

    Thanks Jeff, for some more COOL STUFF.

    Most days I don't have time to read the more lengthy articles, but I did today, and I've been meaning to look into these...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 23, 2008 at 11:00 am

    #819818

  • RE: The CLR

    I know this is a forum by and for SQL Server bigots but there is also the possibility that those of us who are strong in the .Net CLR and...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 15, 2008 at 2:39 pm

    #816145

  • RE: The CLR

    Pardon the redundacy, but does anyone have knowledge of, or better yet experience, porting 32 bit CLR functions to a 64 bit SQL Server.

    I'm pretty sure that the 64 bit...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 13, 2008 at 11:23 am

    #814688

  • RE: The CLR

    Thanks for starting up this topic Steve. I'm very interested in the pros and cons that others express on it.

    Let me put this one at the top: What happens to...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 13, 2008 at 7:38 am

    #814465

  • RE: SQL Server 2005

    But I still don't understand what you mean about turning my statement around. Can you clarify that?

    - GSquared

    I actually was trying to say 'turn my poorly worded comment...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 12, 2008 at 1:47 pm

    #814064

  • RE: SQL Server 2005

    GSquared (5/9/2008)

    I would consider a question about the Resource database valid in an interview (or QotD). In the interview environment, if asked "What are the system databases in SQL...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    May 9, 2008 at 1:30 pm

    #813323

Viewing 15 posts - 211 through 225 (of 322 total)