Forum Replies Created

Viewing 15 posts - 46 through 60 (of 369 total)

  • RE: Declarative Data Integrity

    I responded with the correct answer (2, 1, 0) but was marked Wrong!

    BTW, the code will only run under SQL Server 2008, which wasn't stated. And it will successfully...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 25, 2010 at 8:19 am

    #1108177

  • RE: Database Size

    vk-kirov (1/22/2010)

    So the answer does not (explicitly) depend on model's size, it depends on some SSMS internal algorithm!

    So I'll repeat my earlier statement that the correct answer should have been:...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 22, 2010 at 9:24 am

    #1107419

  • RE: Database Size

    Lynn Pettis (1/21/2010)

    No luck, knowledge. What issues? I simply assumed a default install of SQL Server 2005 (none was specified), made a decision based on what I have...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 22, 2010 at 6:57 am

    #1107306

  • RE: Database Size

    A terrible question! The correct answer, which was not stated, is: "It depends as it is based on the size of the Model database" plus the default for the...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 21, 2010 at 11:43 am

    #1106882

  • RE: SQL 2K5 - Table-Valued Parameters

    Lynn Pettis (1/15/2010)

    I don't read the QotD in the newsletter, I read it on SSC.

    And it is best to answer later in the day as the question is usually rewritten,...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 15, 2010 at 11:42 am

    #1104373

  • RE: Dodge, Dip, Dive, Duck, and Dodge

    bwillsie-842793 (1/14/2010)

    (Extra points if you know what a real bit bucket is and where to find it on an 026...) :hehe:

    I used one to program the 1130.

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 14, 2010 at 1:51 pm

    #1103930

  • RE: Dodge, Dip, Dive, Duck, and Dodge

    The best customer support that I ever had was with Lenovo (ThinkPad). I had a DELL previously but never again.

    Long story short: The issue at the time was...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 14, 2010 at 9:21 am

    #1103708

  • RE: Hibernate

    EdVassie (1/13/2010)

    SOA and OR tools are definitely becoming a standard. They can allow more rapid development than many other approaches, but often come with an implied promise that they...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 13, 2010 at 9:23 am

    #1103148

  • RE: Full Text Index Query seems to be missing a record when querying it

    I strongly suggest that you eliminate the "noise" (stop) words. After several years of continual customer frustration with the "search" feature of our product, we finally killed them. ...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 7, 2010 at 10:01 am

    #1100334

  • RE: t-sql for XML

    See Jacob Sebastian's XML articles:

    XML Workshop X - Working with namespaces

    http://www.sqlservercentral.com/articles/XML/61333/

    XML Workshop XI - Default Namespaces

    http://www.sqlservercentral.com/articles/XML/61334/

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    January 5, 2010 at 6:54 am

    #1098909

  • RE: Generate XML from SQL Server 2005

    Since you are just starting out using XML I suggest that you read Jacob Sebastian's articles on working with XML.

    The article directly related to your problem would be:

    XML...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    December 31, 2009 at 8:39 am

    #1097886

  • RE: Using T-SQL to Transform XML Data to a Relational Format

    Graham O'Daniel (12/30/2009)

    How about using OPENXML?

    I find OPENXML to be fairly useful when translating XML to table data.

    Hope this helps!

    -Graham

    NO! See: Stop Using OPENXML

    http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    December 31, 2009 at 6:56 am

    #1097863

  • RE: MS SQL Server 2008 Full Text Engine

    sturner (12/23/2009)

    If it was an option on installation try running the install again to remove that component separately.

    It is not a separately installable component as it was in SQL Server...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    December 28, 2009 at 7:04 am

    #1096661

  • RE: How SQL server 2005 store utf-8 data type?

    See post 832452 which is a similar problem. It has links to the solutions presented by Microsoft in the BOL. http://www.sqlservercentral.com/Forums/FindPost832452.aspx

    Note that you can successfully Full-Text index data...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    December 23, 2009 at 2:58 pm

    #1096149

  • RE: GMT vs Local Time

    If you are working with historical data, you're in trouble as the dates of the switch in and out of DST changed from year to year. As well as...

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

    December 23, 2009 at 9:29 am

    #1096008

Viewing 15 posts - 46 through 60 (of 369 total)