Forum Replies Created

Viewing 15 posts - 6,376 through 6,390 (of 22,211 total)

  • RE: Temp DB question

    Don't use up all the space on any of your drives. Always have a one or two mb file called "deletemeinemergencies.txt" that you can use to gain a little space...

  • RE: Presentation Advice

    Oh, and don't try to move them out the room. You only have 15 minutes. You can't move kids anywhere in less than 10 minutes.

  • RE: Presentation Advice

    Here's an idea. Something similar to this could work. We did a "deployment" by blowing up balloons, not tieing them off and then asking the audience to get it...

  • RE: Enter today's date etc

    Sean Lange (4/9/2015)


    sqlfriends (4/9/2015)


    Yes, I rarely do that too, but if it is a very simple change, I do that to save time.

    Just curious if SQL server have ability to...

  • RE: Presentation Advice

    That's tough, but for a 10 minute presentation, focus on communicate a single idea. Don't try to cover too much. You want to show the magic of development, find one...

  • RE: How to find the needle in the haystack

    It does sound more and more like a bad plan.

  • RE: Enter today's date etc

    sqlfriends (4/9/2015)


    Yes, I rarely do that too, but if it is a very simple change, I do that to save time.

    Just curious if SQL server have ability to do that...

  • RE: SQL Timeout for client, but no error in SQL logs

    Not a problem. Happy to help. You know where to go if you have questions.

  • RE: Enter today's date etc

    sqlfriends (4/9/2015)


    Do you mean manually enter getdate(), and hit tab, it will show the datetime, that does not work for me, it says invalid value for cell.

    This table has no...

  • RE: Help me with writing a few lines of code..

    I'd suggest more direct control. Write a statement at the beginning that explicitly creates the table using the structure and name you want and then INSERT...SELECT instead of SELECT...INTO.

  • RE: Windows user with SQL Server Authentication

    Only if it's supplied through the connection string. Which, effectively, means no.

  • RE: Enter today's date etc

    Why not use GETDATE, or better still, GETUTCDATE, to retrieve the date and time you're doing your edits. You don't need to manually modify a value.

  • RE: SQL Timeout for client, but no error in SQL logs

    You mean this book?

    Like Gail says, to SQL Server, there's no difference between a client side timeout and you just killing a query that's running in SSMS. Neither one generates...

  • RE: How to find the needle in the haystack

    tcronin 95651 (4/9/2015)


    May have found the needle, started going through the snapshots Idera DM saves, as I scrolled through I noticed there is one stored procedure with about 12 occurances...

  • RE: Anyone Tell me what regular Housekeeping is needed for SQL DB's

    Jeff Moden (4/9/2015)


    Grant Fritchey (4/9/2015)


    Check Database Integrity

    Database Backups

    Log Backups

    Backup Testing

    Statistics Maintenance

    Index Maintenance

    Those are the basics I think.

    Just to add to that fine list... Checks on performance and resource usage (usually...

Viewing 15 posts - 6,376 through 6,390 (of 22,211 total)