Forum Replies Created

Viewing 15 posts - 2,731 through 2,745 (of 3,221 total)

  • RE: Query Hints

    Steve,

    It is hard, and it's really hard when "making up" answers to not collide with something in BOL

    and may I add Technet and MSDN.

    A question for you Steve. ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 16, 2008 at 2:25 pm

    #913457

  • RE: Query Hints

    Having submitted and had published 7 QODs myself I can only say to those of us (myself included) who rant about how misleading a question can be, l It is...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 16, 2008 at 2:08 pm

    #913453

  • RE: Insert Default Values Via View

    First of all let me state that I am not sure of what you want to do, but if it is to create 5 views each with a different default...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 16, 2008 at 12:02 pm

    #913390

  • RE: PIVOT vertical table without Aggregating

    david.c.holley (12/14/2008)

    If I could write the T-SQL then I'd post it. I am presented the data as it exists in the tables and as I need it displayed. Either help...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 15, 2008 at 6:54 pm

    #912890

  • RE: Query Hints

    Not having that much experience as a developer and even less as a DBA I have followed the recommendation

    Because the SQL Server query optimizer typically selects the best execution...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 15, 2008 at 7:45 am

    #912463

  • RE: Using Inputbox results to search for a record in a Sql 2008 Database Table

    One approach is to create a parmaterized query, using the parameter to pass the user input (be sure to trim trailing blank characters from the user's input) to a dynamic...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 14, 2008 at 6:25 pm

    #912278

  • RE: Rank and %Tile

    Read this article, follow its sample T-SQL code, be sure to scroll down to the explanation for "NTile" and I believe a value of 4 will provide you what you...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 14, 2008 at 1:42 pm

    #912259

  • RE: Rank and %Tile

    If my statistics courses did not leave me .... this is about it

    first quartile (designated Q1) = lower quartile = cuts off lowest 25% of data = 25th percentile

    second...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 13, 2008 at 6:44 pm

    #912143

  • RE: Rank and %Tile

    For a reasonable short course, but complete with sample code

    Part 1

    http://www.databasejournal.com/features/mssql/article.php/3773091/SqlCredit--Part-19-Exploring-SQL-2005s-Ranking-Functions--RANK-and-DENSERANK.htm

    Part 2

    http://www.databasejournal.com/features/mssql/article.php/3780311/Exploring-SQL-2005s-Ranking-Functions--NTILE-and-ROWNUMBER.htm

    These articles will definitely get you started.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 13, 2008 at 2:32 pm

    #912096

  • RE: Windows to SqlServer Authentication mode

    "If Windows Authentication mode is selected during installation, the sa login is disabled. If you later change authentication mode to SQL Server and Windows Authentication mode, the sa login remains...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 13, 2008 at 7:21 am

    #912034

  • RE: windows to sqlserver authentication mode

    This is a cross posting with the General Discussion forum. The posting separated by just one minute .....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 13, 2008 at 7:14 am

    #912032

  • RE: how to insert image into a table in sql 2005

    Start by reading:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/b0d8769c-7598-4f97-8162-ace5f182b5bc.htm

    and then:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/996f2f14-51dd-4e92-a422-d5ab417f2d39.htm

    Hope this helps. But note that Microsoft has stated that

    ntext, text, and image data types will be removed in a future version of Microsoft SQL Server....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 13, 2008 at 7:05 am

    #912030

  • RE: sequence of Triggers

    As long as it is NOT more than 3 triggers you can. These 2 links will help you do that

    [urlhttp://www.sqlservercentral.com/articles/SQL+Puzzles/triggerstoexecuteinpredefinedorder/2337/][/url]

    also:

    http://msdn2.microsoft.com:80/en-us/library/ms186762.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 13, 2008 at 6:51 am

    #912028

  • RE: Error when Creating a View

    Asssumed this was just a posting error.

    AS

    Using this and creating the view in the AdventureWorks db - it works O.K. returning 52 rows

    CREATE VIEW HumanResources.vEmployeesTime

    AS

    ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 12, 2008 at 6:11 pm

    #911976

  • RE: Displaying Multiple Results

    Have you looked at the Having clause as used in Group By statements? If not read in BOL

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/463c5e18-f274-474f-9861-1010fe3757b8.htm

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 12, 2008 at 5:33 pm

    #911970

Viewing 15 posts - 2,731 through 2,745 (of 3,221 total)