Forum Replies Created

Viewing 15 posts - 9,511 through 9,525 (of 9,701 total)

  • RE: Cross Joins

    I don't know, Michael.  I've never seen a situation in any of the jobs where I've worked when a Cross join was needed.  Usually, in fact, people are adding them...

  • RE: DBA''''s more scarce in 2007

    So maybe it's not that DBAs in general are more scarce this year.  Maybe it's just good DBAs that are scarce.  Would that be a fair assessment?

  • RE: Transaction Log backup size

    Actually, I'm sure Backup Exec can backup open files with no problems.  Open text files, .doc files, .xls files.  All of which are not SQL Database files. 

    So you just...

  • RE: Transaction Log backup size

    Oh, I forgot to mention...

    Just because the client is doing full backups doesn't mean they're doing transaction log backups.  You can do one without the other (though it's not advisable). ...

  • RE: Transaction Log backup size

    Does Backup Exec actually make SQL database backups or is it backing up the .mdf and .ldf files from the server?

    If the later, then your client has a problem.  Databases can't...

  • RE: DBA''''s more scarce in 2007

    The problem with the shopping list ads is that contracting companies take them seriously and won't submit you for a job if you're missing what they see as the important...

  • RE: Transaction Log backup size

    Naqaraj, you should really open up a new thread about this error instead of piggy-backing on a thread with a different subject. 

    People who read this thread are expecting to...

  • RE: Transaction Log backup size

    You can't do a log backup and a full backup of the same database at the same time.  One will be held up until the other finishes and they may...

  • RE: Cross Joins

    Here's an example.  TableTime has two columns, TimeID and a datetime column.  It is updated every month with the most recent month-end date (for accounting).  You want to pull all...

  • RE: Move DB from 2005 to 2000??

    As others have said, and I have heard personally from the lips of Kimberly Tripp (works for Microsoft on the SQL Server team), you can NOT downgrade from SQL Server...

  • RE: How to skip the first row in an excel workbook

    Bad news.  There is no good way to do what you want to do save editing the excel workbook itself and deleting that first line.  Now if the first row were...

  • RE: Transaction Log backup size

    Check your database options.  AutoShrink on?  AutoClose on?  Auto Create Stats on?  What about your Transaction log checkpoint stuff?

    Chances are the reason the first 3 logs were so huge was...

  • RE: Auto backup Increasing Size Constantly

    What tool are you using to do an Autobackup?  A job scripted out in T-SQL or the DB Maintenance Plan backup stuff?  Or a third party tool like Litespeed?

    This makes...

  • RE: Access is denied when authentication is set to "enable anonymous access"

    If you can't add a non-admin user to the app server and the web server, you may be stuck.  That's the best solution I can think of, is using a...

  • RE: Order Database Design

    I'm glad I could help you out, Cathy.  And Chris actually has some good ideas (the best come from personal experience) that you might want to consider also.

Viewing 15 posts - 9,511 through 9,525 (of 9,701 total)