Forum Replies Created

Viewing 15 posts - 11,806 through 11,820 (of 39,963 total)

  • RE: Exporting Execution Plans - SQL Spackle

    There was a problem with some information missing in the article. My apologies for that. I have corrected the text.

  • RE: Overlapping of data

    Welcome, and as Keith noted, more info is needed.

    Your explanation isn't really clear to me either. What is the range you are avoiding, what are the edge cases and exceptions?

  • RE: space given in DB name and backup failure

    I like Sergiy's advice.

  • RE: run two queries at the same tiime

    You could use osql/SQLCMD to do this as well.

    Use the START command in a command prompt to spawn a process running your query and run that twice consecutively. It will...

  • RE: Reverse Engineering Tool

    I've used ERStudio and liked it. CA ErWin works, but the last version I used (2002-3) was cumbersome. Visio can do some, but cumbersome as well.

  • RE: Minor Problems

    Gary Varga (10/22/2013)


    I have the following criteria for my posts:

    1) There is no existing post that already covers what I would say (although consolidation and/or simplification are viable reasons to...

  • RE: Minor Problems

    tabinsc (10/22/2013)


    Thank you Steve for this article. This is something I need to do but haven't done yet. I guess writing the first one is the most difficult.

    It...

  • RE: DR testing in SQL 2000

    Pause the log shipping jobs that restore. Let new logs continue to be run on the primary and copied over.

    Bring the DR database online (with recovery) and test if things...

  • RE: new table DDL,

    +1 to what Sean wrote. You might index on these four columns if that is how you access things, but that doesn't necessarily relate to the PK.

  • RE: Link to another database system

    I'm not quite sure what you mean by a link to another system. Are you looking to query MySQL, Oracle, or some other system from within SQL Server?

    You can look...

  • RE: Puzzling SQL Update Statement

    Read this and post some DDL/DML and we can likely help. As noted, however, the design probably needs work. If you can't change that, give us some setup and we'll...

  • RE: Fantasy football 2013

    Ray K (10/21/2013)


    (P.S. Steve, did you change your profile icon just for this thread? :-P)

    Nope, should be changed on all threads. At least, I hope so.

  • RE: Grow Your Family

    You shouldn't have twitter on all the time. I'd check it 5 minutes a day, maybe see if there's something to interact with, and ignore it the rest of the...

  • RE: Storage arrays/RAID configurations

    Don't get caught up too much in the R5 penalty. It certainly is a bigger hit than R1/R10, but I've run SQL Server databases for years on R5 and it...

  • RE: Grow Your Family

    Miles Neale (10/21/2013)


    I got a twitter account two years back and have used it just a little. The entire experience was useless.

    Maybe it is time to try again.

    M.

    You need...

Viewing 15 posts - 11,806 through 11,820 (of 39,963 total)