Forum Replies Created

Viewing 15 posts - 24,526 through 24,540 (of 39,818 total)

  • RE: how to tell when database was last used

    If you think this database might not be used, then set AutoClose and when someone accesses it, an entry will go into the error log.

    Note that you don't want this...

  • RE: Question about Sp calling another sp

    Please don't delete the post. If you find out the information, post the answer as a response. It helps others learn that might have a similar problem.

  • RE: SQLServerCentral To Take Over PASS

    Not sure I want to joke about us taking over SQL Server development, they might buy us and make us help! :hehe::-P:w00t:

  • RE: The March 2009 Car Update

    Doug Beers (4/1/2009)


    The summer car is a Corvette that gets 29 mpg cruising on the interstate.

    Wow, that's pretty good. I need to run the 911 through a tankful on the...

  • RE: Fetching Remote servers properties

    These are constants, no from needed.

    select serverproperty( 'servername')

    , spid

    from sysprocesses

    The same as

    select 1

    , spid

    from sysprocesses

    Please post in the appropriate forum. Moved to 2005 admin

  • RE: The SQL Server Easter Egg

    Adam,

    sorry you didn't like it. Was trying for something a little different this year.

  • RE: SQLServerCentral To Take Over PASS

    Sorry for the delays on this one. I mistakenly didn't publish it and it wasn't ready until the am.

    The Paypal note actually isn't a joke. We sold tickets last year...

  • RE: The March 2009 Car Update

    you're kind of assuming that purchasing that luxury car does those things. It's debatable to what extent that happens.

    Humans do many short-sighted decisions. No doubt about that. I'm just not...

  • RE: Are the posted questions getting worse?

    CLEAR!

    thump-thump

    thump-thump

    We're still going.

  • RE: The March 2009 Car Update

    I'm not sure most people made bad choices. there are always some that made poor financial choices, but buying a larger car, or a less efficient car because you liked...

  • RE: Are We Wasting Too Much Time Social Networking?

    It goes both ways. It may or may not have a relation. You can't stereotype people using social networking at non-social in the real world.

    There are plenty of SQL...

  • RE: The March 2009 Car Update

    Our decision to buy the Prius was an economic one. Based on the costs, choices we wanted, tax credit, etc., the Prius was the best fit. We've saved a bunch...

  • RE: Error log

    Something happened in your i/o system and it rendered the copy-on-write a failure in the snapshot. When SQL detects an issue, it tends to just whack the snapshot. It doesn't...

  • RE: The March 2009 Car Update

    Yes, we've been frivolous in the US, yes we've wasted efforts. However I'm not sure that we all have just wanted SUVs. If you look back, there have been trends,...

  • RE: tempdb full

    You need to trace this and find out which activity is growing tempdb. There is no other way, live server or not. Activity, and possibly large transactions using temp tables/variables,...

Viewing 15 posts - 24,526 through 24,540 (of 39,818 total)