Forum Replies Created

Viewing 15 posts - 5,701 through 5,715 (of 7,164 total)

  • RE: Increasing CPUs hurts Perf

    I am interested to know the disk subsystem differences too.

    Also, with MAXDOP now set to 0 what do your wait stats look like? And what was MAXDOP on the old...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 3:01 pm

    #1347358

  • RE: Are the posted questions getting worse?

    jcrawf02 (7/1/2011)

    GilaMonster (7/1/2011)

    Thanks everyone. Wasn't actually planning on announcing it here.

    Thankful that you received it, but we didn't need anyone else's validation of your impact. 🙂

    Ditto. Like there was any...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 2:24 pm

    #1347339

  • RE: Instance count

    shanila_minnu (6/30/2011)

    How to find out the number of instances installed in a sql server 2000

    Just to clarify, number of instances installed in a sql server 2000 is kind of misleading....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 2:14 pm

    #1347329

  • RE: Help with SQL query

    You're talking about a "catch-all query". Please have a look at this article[/url] by Gail Shaw. It is the article for reference on the topic and will get you where...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 2:07 pm

    #1347324

  • RE: A Little Interviewing Advice

    sturner (7/1/2011)

    ...But I digress...

    Wow, now there's an understatement :hehe:

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 2:01 pm

    #1347321

  • RE: Sabbaticals

    The place where I am working now offers sabbaticals after you have been with the company for 5 years. My team has 32 people, and already 3 people have taken...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 1:50 pm

    #1347312

  • RE: sys.dm_db_index_usage_stats

    ...checking on something

    EDIT:

    OK, had to make sure:

    Restarting SQL makes the index disappear from the usage stats view altogether. It's not until the index is used again (in some way) that...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 12:29 pm

    #1347259

  • RE: How do i get my cursor to continue running after an error is raised

    Just for the record, I prefer PowerShell for this kind of work. It can do all the file system and T-SQL stuff with ease all within the same programming domain.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 12:18 pm

    #1347256

  • RE: Restore database with dynamic path

    Wildcat (7/1/2011)

    Tara-1044200 (7/1/2011)

    I want to create a proc that restores a database every week. Lets say i want to restore a database "Employee" every sunday, here are the steps i...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 12:13 pm

    #1347253

  • RE: How do i get my cursor to continue running after an error is raised

    kramaswamy (7/1/2011)

    Yeah I know - I wouldn't recommend using xp_cmdshell, but if for whatever reason he doesn't have access to a visual studio environment to create a CLR with, then...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 12:10 pm

    #1347251

  • RE: How do i get my cursor to continue running after an error is raised

    kramaswamy (7/1/2011)

    GSquared (7/1/2011)

    I don't think there's a way to do that in T-SQL. My solution on similar scripts has been to check for the existence of the folder, and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 11:56 am

    #1347243

  • RE: PowerShell Job Agent does not work?

    Copy is a Windows CmdShell command. Try using the Copy-Item PowerShell CmdLet and set the -ErrorAction set to Stop

    Copy-Item -Path \\V240\folder\foo.txt -Destination \\V240\folder\bar.txt -ErrorAction Stop

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 11:35 am

    #1347236

  • RE: parallel execution of a stored proc?

    Service Broker can assist you with getting asynchronous behavior.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 11:18 am

    #1347219

  • RE: Transaction Log

    Syed,

    Here is an article for your review. It will give you the information you need to determine which of your stored queries should be updated:

    Mapping System Tables to System...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 11:14 am

    #1347215

  • RE: Restore database with dynamic path

    Tara-1044200 (7/1/2011)

    I want to create a proc that restores a database every week. Lets say i want to restore a database "Employee" every sunday, here are the steps i want...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 11:01 am

    #1347200

Viewing 15 posts - 5,701 through 5,715 (of 7,164 total)