Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    LutzM (4/23/2011)

    GilaMonster (4/23/2011)

    Jack Corbett (4/23/2011)

    So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.

    http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx

    Want to swap? I'm having some amusement with...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 23, 2011 at 1:25 pm

    #1315171

  • RE: Are the posted questions getting worse?

    WayneS (4/22/2011)

    Koen Verbeeck (4/22/2011)

    WayneS (4/22/2011)

    Did you know that most windows programs (including SSMS; not Notepad) allow you to select COLUMNS of text? Position the cursor at the starting position, and...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 22, 2011 at 4:24 pm

    #1315055

  • RE: Row size, indexes and varchar(max)

    titan2782 (4/22/2011)

    thanks for that info. After i made the changes, it looks like the query runs slower now. Even though the row size is 6kb and I dropped/rebuilt all indexes....

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 22, 2011 at 12:57 pm

    #1315008

  • RE: Music Server for a budget Audiophile

    mtillman-921105 (4/12/2011)

    'Anyone else using their computer as a source for their home stereo? Your advice is welcome here.

    I have an old PC that I plan to use for a...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 22, 2011 at 12:41 pm

    #1314997

  • RE: SSIS 2008: can't change connection string in existing connection manager

    Bozohead Jones (4/22/2011)

    Thank you for quick reply!

    Soon after I posted, I believe I've figured this out. The package has a hardcoded path to a dtsConfig in the old project!...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 22, 2011 at 12:37 pm

    #1314994

  • RE: SSIS 2008: can't change connection string in existing connection manager

    Also, once you change the connection, you have to go through and manually change every task that used that connection, primarily to make sure the tables and rows that are...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 22, 2011 at 12:31 pm

    #1314989

  • RE: SSIS 2008: can't change connection string in existing connection manager

    Bozohead Jones (4/22/2011)

    I'm attempting to use an old package as a starting point for a new project. Of course, the first thing I want to do is point it...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 22, 2011 at 12:25 pm

    #1314987

  • RE: Not Able to fire Command Line due to Space in the Directory Name

    JCSQL (4/22/2011)

    This is VERY frustrating as I actually have this working on several servers but it is not working in my current code. I KNOW I am missing something stupid...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 22, 2011 at 12:19 pm

    #1314980

  • RE: Configure SQL Server Agent Mail to Use Database Mail (T-SQL?)

    This should be a good starting place for you

    http://msdn.microsoft.com/en-us/library/ms175862.aspx

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 22, 2011 at 11:57 am

    #1314968

  • RE: Layered Status report (column to row)

    kazim.raza (4/21/2011)

    Hi,

    I need to prepare a report that describes user status and the time spent in transitioning from one status to another, for instance,

    User arrives at work, logs in, and...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 22, 2011 at 10:01 am

    #1314920

  • RE: Row size, indexes and varchar(max)

    titan2782 (4/21/2011)

    no. they are infrequently used columns

    Oh good. You should look into making them SPARSE columns. You can save a lot of space that way.

    http://msdn.microsoft.com/en-us/library/cc280604.aspx

    If they aren't in the index,...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 21, 2011 at 6:08 pm

    #1314763

  • RE: Must declare the variable '@Name' issue

    dianaansari (4/21/2011)

    I am using SQL to enter data from asp.net/c# language. A link button on asp.net webpage will allow the user to enter the data into and that data will...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 21, 2011 at 2:03 pm

    #1314704

  • RE: Must declare the variable '@Name' issue

    dianaansari (4/21/2011)

    I do not know if I am in the right thread, but I am having a SQL issue.

    When I debug my web-page it shows me this error:

    Must declare...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 21, 2011 at 12:59 pm

    #1314681

  • RE: Row size, indexes and varchar(max)

    titan2782 (4/21/2011)

    I have a table with 100m+ rows. We're seeing very bad performance on queries as the data grows. I noticed that the row size is pretty big (10190) and...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 21, 2011 at 12:56 pm

    #1314679

  • RE: What columns should be chosen when partitioning a table?

    kwoznica (4/21/2011)

    Stefan,

    I am going to give this a go keeping in mind all the points you brought up. If you have some time can you look at the code...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 21, 2011 at 9:17 am

    #1314571

Viewing 15 posts - 1,846 through 1,860 (of 2,838 total)