Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 7,168 total)

  • RE: partition_id VS. hobt_id

    GilaMonster (3/3/2013)

    They were added as separate columns to support a feature that was planned, partially added to SQL 2005 and later scrapped.

    You know I am curious about these kinds of...

    March 8, 2013 at 8:01 am

    #1594977

  • RE: partition_id VS. hobt_id

    In SQL Server 2008/R2 the two columns will always have the same value.

    ...and, I am almost sure, in SQL 2012 the same columns again will be just duplicate one another?

    Sorry,...

    March 8, 2013 at 8:00 am

    #1594976

  • RE: Creating a reference table.

    brian.geregach (3/7/2013)

    I was thinking of a child table for each of the three columns. Otherwise I'm not sure I understand your question.

    OK, I think I know what you mean...

    March 8, 2013 at 7:58 am

    #1594971

  • RE: Today's Random Word!

    JAZZ Master (3/8/2013)

    crookj (3/8/2013)

    SQLRNNR (3/7/2013)

    crookj (3/7/2013)

    Daniel Bowlin (3/7/2013)

    Help

    Support

    Truss

    Tether

    Tie

    Bolo

    March 8, 2013 at 7:22 am

    #1594954

  • RE: Issue with custom SSIS powershell task

    That's an error from SQL Doc and would not be related to this.

    Try looking in the Agent Job History log. Right-click the job and select View History.

    March 8, 2013 at 7:20 am

    #1594953

  • RE: Create File without xp_cmdShell

    A SQLCLR object can access the file system too, and it would be the lesser of two evils in this case, when compared to enabling xp_cmdshell, but still not ideal....

    March 7, 2013 at 9:36 pm

    #1594793

  • RE: modifying a SP

    ntreelevel (3/7/2013)

    Hi my condition is that I already have a sp and I have to add this code and modify the sp so that it returns a column supervisor...

    March 7, 2013 at 9:30 pm

    #1594788

  • RE: How to find all column dependencies including triggers?

    arnipetursson (3/7/2013)

    Search for the column name in syscomments

    syscomments is there for backward compatibility only.

    Use sys.sql_modules in SQL 2005 and newer. The definition column contains the T-SQL code for the...

    March 7, 2013 at 9:01 pm

    #1594777

  • RE: UPDATE failed because the following SET options have incorrect settings:

    RamSteve (3/6/2013)

    I Created a UniqueIndex on a Test Table with Some condition as below and user were getting error msg as below while updating the test table by using the...

    March 7, 2013 at 4:24 pm

    #1594745

  • RE: Creating a reference table.

    brian.geregach (3/7/2013)

    The columns that I think should go into their own table are:

    Priority - a number from 1 - 4

    Assignee - User or group ticket is assigned to

    Category - 1st...

    March 7, 2013 at 2:55 pm

    #1594710

  • RE: Creating a reference table.

    brian.geregach (3/7/2013)

    here is the information you were asking for:

    CREATE TABLE [dbo].[Tickets](

    [Ticket Number] [int] NOT NULL,

    [Priority] [smallint] NULL,

    [Assignee] [varchar](25) NULL,

    [Category] [varchar](25) NULL,

    [Vendor Ticket] [varchar](60) NULL,

    [Open Date] [date] NULL,

    [Opener] [varchar](30) NULL,

    [Closer] [varchar](30)...

    March 7, 2013 at 2:02 pm

    #1594695

  • RE: Result of dynamic sql with parameteres into a variable

    With proper indexing and query writing that number of rows will not be an issue. I have tables with many billions of rows in them.

    March 7, 2013 at 1:56 pm

    #1594691

  • RE: View results into string

    jmceuin (3/7/2013)

    Sorry missed that. And I did more tinkering and just added and additional GROUP BY POPRCTNM to the very end of the statement rather than in the middle and...

    March 7, 2013 at 1:54 pm

    #1594689

  • RE: Creating a reference table.

    First off, welcome to SQL Server Central (SSC). This is a great community-site to learn more about SQL Server.

    brian.geregach (3/7/2013)

    I am very new to SQL Server. I have a...

    March 7, 2013 at 1:49 pm

    #1594687

  • RE: View results into string

    jmceuin (3/7/2013)

    Also, the GROUP_CONCAT option doesn't work. Apparently that is a MySQL feature not on MS SQL 2008.

    Did you read the CodePlex site I linked to? dbo.GROUP_CONCAT() is a SQLCLR...

    March 7, 2013 at 1:31 pm

    #1594682

Viewing 15 posts - 1,696 through 1,710 (of 7,168 total)