Forum Replies Created

Viewing 14 posts - 346 through 360 (of 360 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...

    Quand on parle du loup, on en voit la queue

  • 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...

    Quand on parle du loup, on en voit la queue

  • 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...

    Quand on parle du loup, on en voit la queue

  • 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...

    Quand on parle du loup, on en voit la queue

  • 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...

    Quand on parle du loup, on en voit la queue

  • 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....

    Quand on parle du loup, on en voit la queue

  • 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...

    Quand on parle du loup, on en voit la queue

  • 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...

    Quand on parle du loup, on en voit la queue

  • 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...

    Quand on parle du loup, on en voit la queue

  • 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...

    Quand on parle du loup, on en voit la queue

  • 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...

    Quand on parle du loup, on en voit la queue

  • 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

    Quand on parle du loup, on en voit la queue

  • 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.

    Quand on parle du loup, on en voit la queue

  • 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

    Quand on parle du loup, on en voit la queue

  • Viewing 14 posts - 346 through 360 (of 360 total)