Forum Replies Created

Viewing 15 posts - 3,541 through 3,555 (of 7,429 total)

  • RE: Slow Queries

    Sorry about that Scorpion. I just enjoy the challenge. I am trying to back off bu it is like a drug to me. So I am focusing here soon on...

    January 17, 2003 at 5:57 pm

    #446695

  • RE: Suddenly No ID/Password Check

    If you know what user it is logging in as change the password. Then it should fail and popup the login on Access. I think you will find somewhere along...

    January 17, 2003 at 5:32 pm

    #446692

  • RE: Count off when using distinct and group by

    Which is smaller?

    January 17, 2003 at 5:29 pm

    #446691

  • RE: Estimating Table size

    Best way is too look at the size of each column, add the amounts (even for variable length columns) and multiply by the number of estimated rows.

    For instance

    int = 4...

    January 17, 2003 at 5:22 pm

    #446689

  • RE: Slow Queries

    The key is firs to look at the fields you actually need from the views and determine the if maybe a new view instead of your current view calling a...

    January 17, 2003 at 5:18 pm

    #446688

  • RE: NULL Storage Space

    Ok when the data is stored and looked at in hex at the page level there are a few things that occurr.

    First the row contains a header that tells if...

    January 17, 2003 at 3:03 pm

    #446685

  • RE: Here's a fun one! :)

    quote:

    WooHoo! We have a flaming folder!

    Glad I could help...

    January 17, 2003 at 10:55 am

    #446667

  • RE: Here's a fun one! :)

    quote:

    In my keenness to post a reply, I neglected to join in the 'debate'

    The query uses a cross join

    select a, b, c,...

    January 17, 2003 at 10:54 am

    #446666

  • RE: Here's a fun one! :)

    Interesting approach there David. I would have probably done exactly what sjcsystems suggested with PK or unique value and did a temp table to order and join to. However David's...

    January 17, 2003 at 10:46 am

    #446664

  • RE: Here's a fun one! :)

    Ok let's have a little fun then. What happens if the table is defined like so.

    CREATE TABLE testC (

    a char(2000) NOT NULL,

    b char(2000) NOT NULL,

    c char(2000) NOT NULL,

    d char(2000) NOT...

    January 17, 2003 at 10:21 am

    #446658

  • RE: Who Needs Change Management?

    I have enough Daves to tell you if I could ever get agreement on the process of this I would love it. Usually the problem is fixing something breaks something...

    January 17, 2003 at 10:00 am

    #446652

  • RE: Securing a payroll application

    SA and DBA need to be able to access the data to verify when issues arise. Yes, I would put apps with specific security needs on their own server and...

    January 17, 2003 at 9:16 am

    #446641

  • RE: Storing 00 to 111111111111

    Why would you store

    110 for 2 questions and not

    11 = 3 for 2 questions.

    And in the future what happens if you add or remove questions what do you plan to...

    January 17, 2003 at 9:14 am

    #446639

  • RE: Family members

    Oops, pays to read the rest I guess. Is this part of a maintainence plan. If so have you done stripped backup sets in the plan maybe?

    January 17, 2003 at 7:24 am

    #446618

  • RE: Selecting Null field from database.

    Use

    WHERE Parnet_ID IS NULL

    Check out this article for a bit of info on how IS NULL works

    http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp

    January 17, 2003 at 7:01 am

    #446613

Viewing 15 posts - 3,541 through 3,555 (of 7,429 total)