Forum Replies Created

Viewing 15 posts - 751 through 765 (of 2,894 total)

  • RE: Configuring Line Graphs in SSRS for color blind?

    1) Select a standard palette that does not mix reds with greens

    ...

    Is not as simple as that. There are many different types of vision deficiencies. You may need to...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 7:47 am

    #1570917

  • RE: When does SIX lock occurs?

    Some relevant discussion on this forum:

    http://www.sqlservercentral.com/Forums/Topic1227558-1292-1.aspx#bm1227579

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 7:39 am

    #1570913

  • RE: When does SIX lock occurs?

    So, you have read this:

    http://msdn.microsoft.com/en-us/library/aa213039(v=sql.80).aspx

    Shared with intent exclusive (SIX)

    Indicates the intention of the transaction to read all of the resources lower in the hierarchy and modify some (but not all)...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 7:36 am

    #1570910

  • RE: Unwanted parameter truncation

    pdanes (12/21/2012)

    Eugene Elutin (12/21/2012)

    If your input parameter is just a list of character-separated values, then you can make it just VARCHAR(MAX), then use split function to split it into table...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 7:33 am

    #1570909

  • RE: Table and SP cannot have same name

    Shadab Shah (12/21/2012)

    Al right .But they are totally different object . I mean to say one is a table and another SP. So that means you are saying that i...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 7:19 am

    #1570903

  • RE: Table and SP cannot have same name

    Shadab Shah (12/21/2012)

    Hi,

    Since i am newbie to SQL Server, i am finding some new things.

    1. I have a table in dbo schema named as Demo

    2. I tried creating SP with...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 6:49 am

    #1570884

  • RE: Unwanted parameter truncation

    If your input parameter is just a list of character-separated values, then you can make it just VARCHAR(MAX), then use split function to split it into table inside of proc...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 6:39 am

    #1570880

  • RE: pattern matching?

    Without artificial intelligence which is on pair with clear human knowledge which names refer to the same company and which one, even very similar ones, are not, it is simply...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 6:04 am

    #1570869

  • RE: joins

    You can clearly see in your execution plan that SQL performs full table/index scans for all of your tables used in queries, together with using HASH MATCH join which is...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 5:12 am

    #1570853

  • RE: joins

    Any indexes?

    You join on non-key columns, so do you have indexes on them?

    Can you also post current execution plan.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 4:15 am

    #1570834

  • RE: ORDER BY Should be same as my input in IN()

    GilaMonster (12/21/2012)

    Josh Ashwood (12/20/2012)

    GilaMonster (12/20/2012)

    Can you imagine all the simple

    SELECT Foo FROM Foo, Bar WHERE Foo.X *= Bar.Y

    haha *=

    Now that is real dinosaur stuff!!

    You'd think...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 4:02 am

    #1570829

  • RE: joins

    kapil_kk (12/21/2012)

    ...

    I cant give you the table structure as there are lots of tables...

    plz tel me how can I improve the performance of this query

    To improve the performance of your...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 3:59 am

    #1570828

  • RE: Configuring Line Graphs in SSRS for color blind?

    DataAnalyst011 (12/19/2012)

    Has anyone ever needed to make a chart (especially a line graph) in SQL Server Reporting Services user-friendly for color blind users? I've been brainstorming of various ways, but...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 20, 2012 at 10:07 am

    #1570602

  • RE: Table has no natural primary key and no clustered index

    Kwisatz78 (12/20/2012)

    Hi all

    I am wondering what is best practice when a table has no natural primary key and no clustered index, what is the best thing to do in regards...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 20, 2012 at 9:56 am

    #1570599

  • RE: Slow running query

    ... I woud think that if there was a major problem with the query that it would always take a while to retrieve but that is not the case.

    My question...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 20, 2012 at 8:34 am

    #1570575

Viewing 15 posts - 751 through 765 (of 2,894 total)