Forum Replies Created

Viewing 15 posts - 91 through 105 (of 322 total)

  • RE: Database Size

    timfle (1/22/2010)

    does anyone read MS documentation? Do you people even have the fainest idea what the "MODEL" database is used?

    Obviously vk kirov doesn't (although I have worked with...

    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

    January 22, 2010 at 3:36 pm

    #1107625

  • RE: Database Size

    One more log for the fire.

    I ran a simple CREATE DATABASE mydb using SQL Query Analyzer against my 2005 Developer edition, and the size came out to 1.68 compared 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

    January 22, 2010 at 7:26 am

    #1107324

  • RE: SQL Server 2008 Policy-Based Management

    Policies are not an item that I have worked with yet, but I do have to pass the #70-432 this year, and I'm sure knowing this is helpful.

    Thanks.

    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

    January 18, 2010 at 10:35 am

    #1105033

  • RE: Session Settings

    Learnt sump'n. Thanks, BitBucket!

    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

    January 12, 2010 at 8:07 am

    #1102451

  • RE: Server Administration

    I never gave a thought to 64 bit Windows/SQL Servers having different built in memory allocation settings than the 32 bit versions.

    In fact, I figured that Windows Server 2008 wouldn't...

    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

    January 11, 2010 at 8:05 am

    #1101804

  • RE: Balancing the Message

    Following an interesting thread can be worthwhile and yet take some time to do when it is many pages. I would feel kind of let-down to follow a notification back...

    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

    January 9, 2010 at 1:29 pm

    #1101430

  • RE: T-SQL

    Steve Jones - Editor (1/7/2010)

    the answer is predicate. It has not changed. The change from

    "IN"

    to

    "columnX IN (x, y, z, ...)"

    Makes it a predicate.

    Maybe you should check it again...

    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

    January 7, 2010 at 1:36 pm

    #1100482

  • RE: T-SQL Output Clause

    robert_edis (1/6/2010)

    I am a little confused.

    If the UPDATE statement has a WHERE clause of CategoryID = 7 but no records have been previously loaded then it cannot write any data...

    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

    January 6, 2010 at 4:58 pm

    #1099977

  • RE: T-SQL Output Clause

    Just because the question references a (the) Northwind db doesn't mean that you have to have one to answer the question. You have to figure that the question did fit...

    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

    January 6, 2010 at 3:50 pm

    #1099963

  • RE: SSRS 2008, using BIDS/VS 2008 for report design.

    :-)Ah yes... The old CTRL + ALT + D immediate reboot command.:-)

    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

    January 5, 2010 at 10:06 am

    #1099045

  • RE: Can Users Be Trusted?

    😉

    Unsecure apps are always a problem, but what makes an app Insecure? Do they come from broken homes? I don't think I would trust them either.

    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

    December 22, 2009 at 3:06 pm

    #1095729

  • RE: SQL 2005 inplace upgrade

    If you install 32 bit ODBC client applications on the server, or any 64 bit machine, you must use the 32 bit ODBC Administrator (%SystemRoot%\SysWOW64\odbcad32.exe) to setup your DSN. You...

    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

    December 7, 2009 at 2:58 pm

    #1088928

  • RE: All-in-one

    I think I prefer to have more smaller tools. The article made me ask myself why I still use SQL Server 2000 QA for most of my work. I think...

    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

    December 4, 2009 at 5:04 am

    #1087585

  • RE: Datetime precision

    peter.house (11/30/2009)

    While looking at the answer choices, my brain kept saying "Yesterday Midnight + 100ms"

    For me, Midnight today is tonight and the SQL answer is this morning at 100ms after...

    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

    December 2, 2009 at 8:38 am

    #1086561

  • RE: Variables, Nulls and Coalesce

    Ya got me.

    :crying:

    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

    November 25, 2009 at 1:54 pm

    #1084342

Viewing 15 posts - 91 through 105 (of 322 total)