Forum Replies Created

Viewing 14 posts - 346 through 359 (of 359 total)

  • RE: SQL Design Standards

    Jodie,

    How experienced are your coders in SQL Server? How quickly do you follow up on assignments? We have a 30 minute rule - if you are still working on the...

  • RE: No Clustered Index

    quote:


    I imagine there are times that due to the small amount of data, the query planner may opt for a table scan...

  • RE: Shrinking databases below original size

    quote:


    I am using SQL Server 7. I have tried shrink file and it does nothing because the database was set up originally...

  • RE: No Clustered Index

    quote:


    Nope. If you don't have a column that is really worth using it on, at least use it on your primarykey.

    Andy

    Do...

  • RE: obtaining list of NT Groups for given NT user name

    I tried to solve this problem a year and a half ago. I tried many stored procedures (most undocumented) and I found nothing. The client decided after discussing the many...

  • RE: Shrinking databases below original size

    Which version of SQL Server? Shrinkfile was not around for version 6.5 or before.

    Shrinkdb won't allow the database to be shrunk below the absolute minimum size.

    Shrinkfile debuts with Version 7....

  • RE: What other dba hats do you wear?

    Ok. Three types of SQL Servers (versions 6.5 to 2000) I maintain them and write stored procedures. Win2K networking (servers and all types of clients), but not full time, usually...

  • RE: Death of the Production DBA

    Well, it depends. The perception that SQL Server is easy will continue the flow of dabbling developers. Access has been used to create some incredibly ugly databases (ugly in many...

  • RE: SQL6.5 on Win2K Professional

    Yes, Win2K Pro has the same 10 user connection limit that NT Workstation has.

    quote:


    I believe the NT WK and Win2K Pro have...

  • RE: What are certification benefits???

    I have worked for some employers who care about the exams, some who don't.

    And yes, after a while you get very good at answering odd questions.

    As for the salary...

  • RE: Books On Line

    Yes. $$$. My clients seem to have none to spend on upgrading. They will spend $$$ on the tortuous stored procedures though.

    The jump from SQL Server 2000 to SQL Server...

  • RE: Books On Line

    Andy,

    Yes, that's me.

    Pat

    quote:


    Patrick,

    Is this you? http://www.microsoft.com/trainingandservices/default.asp?PageID=training&SubSite=success

    Andy


    Patrick Birch

    MCT, MCDBA, MCSD

  • RE: Books On Line

    Thanks. I sent off an email.

    I have several clients who hold on dearly to their 6.5 servers. I would love to work on only one version.

    September 14, 2001 at 10:22 am

    #418244

  • RE: SQL 2000 Administration Exam

    Experience works best. Make sure you understand the concepts and could explain them to someone else.

    Patrick Birch

    MCT, MCDBA, MCSD

Viewing 14 posts - 346 through 359 (of 359 total)