Search:

Type: Posts; User: gb1983

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds.

  1. Replies
    10
    Views
    1,644

    Re: Parameter Sniffing

    Thats great, thanks for your help with this.

    Another quick question.

    The PLAN_HANDLE which is assigned to a plan: Does this change if a plan is recompiled, or does it remain the same?

    I'm...
  2. Replies
    10
    Views
    1,644

    Re: Parameter Sniffing

    Thanks for your replies.

    @ GaryMazzone - If you do replace your parameter with a local variable, does this then force a recomile every time the Stored Proc is executed, in the same way that a...
  3. Replies
    10
    Views
    1,644

    Re: Parameter Sniffing

    I agree, it does sound like the problem.

    Parameter sniffing means that the original plan is re-used (albeit with sub-optimal parameters). Isn't the whole point of execution plans to encourage...
  4. Replies
    10
    Views
    1,644

    Re: Parameter Sniffing

    Thanks for your reply.

    We are basically seeing poor performance from a specific query wich runs numerous times. When the plan for this query is removed from the cache, then the performance...
  5. Replies
    10
    Views
    1,644

    Parameter Sniffing

    Hi,

    I understand that Parameter Sniffing will cause the execution of a query to be based on a previous plan with different parameters, and this can cuase performance issues because the parameters...
  6. Replies
    3
    Views
    579

    Re: Subversion question.

    Its a code management tool like Visual Sourcesafe.
  7. Replies
    3
    Views
    579

    Subversion question.

    I'm not sure which section this quesiton should be in as it is related to code management.

    I need the command line code to tell me which files have been comitted through SubVersion between...
  8. Thread: Dynamic Index

    by gb1983
    Replies
    3
    Views
    481

    Re: Dynamic Index

    The column order is actually very important in the way in which the index is used. If you have created indexes with columns in a random order then i suggest reading up on this topic, as they will not...
  9. Thread: Dynamic Index

    by gb1983
    Replies
    3
    Views
    481

    Dynamic Index

    Hi,

    I need to add numerous indexes to imrpove performance. Usually I would look at the queries being executed and add the indexes to the required columns based on the query. However, the columns...
  10. Thread: Pivot query

    by gb1983
    Replies
    1
    Views
    465

    Pivot query

    Hi, i would like to output the following inside SQL Server 2008.


    Column Name Index_1 Index_2 Index_3
    Column_1 yes No ...
  11. Thread: Convert a Date

    by gb1983
    Replies
    5
    Views
    811

    Re: Convert a Date

    ABHIJIT: I'm using SQL Server 2005

    koolsid: Format cannot be used in SQL Server
  12. Thread: Convert a Date

    by gb1983
    Replies
    5
    Views
    811

    Convert a Date

    Hi I have an issue where my new date values are being automatically converted. I have tried the following:

    I have a field which I select the latest record and add 7 days to it as follows:
    ...
  13. Replies
    5
    Views
    674

    Re: SQL to concatenate

    Here you go.


    SELECT P.PID, C.Name
    from tblParent P INNER JOIN tblChild C ON P.PID = C.PID

    This will give the following output


    PID Name
  14. Thread: Query Index

    by gb1983
    Replies
    3
    Views
    520

    Re: Query Index

    Can you explain please
  15. Thread: Query Index

    by gb1983
    Replies
    3
    Views
    520

    Re: Query Index

    Anyone...???
  16. Re: Help needed for data insertion by multiple user !!!

    Adding an extra column is the best option. Two users trying to insert at the same time will cause a deadlock which will in turn kill one of the proccesses, meaning that one of the inserts will fail....
  17. Thread: Query Index

    by gb1983
    Replies
    3
    Views
    520

    Query Index

    Hi,

    When querying index statistics against my SQL 2005 environment, I am seeing mulitple entrees for the same Index with different percentages.

    I am using the following query


    SELECT...
  18. Replies
    3
    Views
    397

    Re: SQL Server 2005 Backup

    Ok, thanks for you help. If I don't use the 'Move' command, will the files be restored in the default location in the SQL Server folder.?
  19. Replies
    3
    Views
    397

    SQL Server 2005 Backup

    I'm currently working on a backup / restore strategy, but am encountering an issue. Please can someone help me with the following issue:


    - I have taken a full backup of a database.
    - I would...
  20. Replies
    4
    Views
    594

    Re: SQL Server 2005 Database Backup

    OK, thanks for your help.
  21. Replies
    4
    Views
    594

    Re: SQL Server 2005 Database Backup

    OK, thanks. So a maintenance Plan is the best option?
  22. Replies
    4
    Views
    594

    SQL Server 2005 Database Backup

    Hi,

    I'm about to set a schedule up to automatically create a full, and then differential daily backups of one database.

    My question is:

    Do most DBA's do this using a script which is called...
  23. Replies
    1
    Views
    372

    Restore a Database

    Hi,

    Can someone please tell me what the 'WITH FILE = 1' part of the statement below means please. I am restoring a full and differential backup, I'm just not sure why the differential is 1? Does...
  24. Thread: Asp - xaml

    by gb1983
    Replies
    1
    Views
    440

    Asp - xaml

    Hi,

    I currently work on a web app built in classic asp. It is hosted in IIS on a single server and accessed by numerous users.

    I would like to re-write this app as a side project in a more...
  25. Replies
    0
    Views
    343

    Crystal Report XI: Date Question

    Hi,

    I have a report in Crystal which I know will never use more than one page. I would like the user to select a month name as a parameter and then each page to be dated with each day of the...
  26. Replies
    1
    Views
    2,795

    Host WCF Service

    Hi,

    I have the following instructions which are auto generated when creating a WCF Service. My question is:

    What is meant by the term 'host' in relation to the service??

    Is this referring to...
  27. Replies
    2
    Views
    2,790

    Re: WCF Service Contracts

    Thanks for your help.
  28. Replies
    2
    Views
    2,837

    enumprinters Question

    Hi

    I have the following code which checks for installed printers. My question is: What is returned in the retval variable from the function?
    Also, I believe that the Number of Printers found is...
  29. Replies
    0
    Views
    490

    Urgent: Crystal Parameter Issue

    Hi,

    I have a parameter issue. I published a report from Crystal to Business Objects, overwriting the original. The only change i made was to change a parameter from Single Value to Multi Value....
  30. Replies
    2
    Views
    2,790

    [RESOLVED] WCF Service Contracts

    Hi,

    I've been reading up on WCF online / books etc.

    If possible, please could you let me know if the following is correct.

    1. A Service Contract is created in the form of an interface by...
  31. Thread: WPF/WCF with C#

    by gb1983
    Replies
    1
    Views
    3,714

    WPF/WCF with C#

    Hi,

    I am currently and have been for approx 5 years - a VB6 developer. I write software which is windows forms based, and distributed also.

    I have been learning c# for about 3 months. I have a...
  32. Thread: Basic Question

    by gb1983
    Replies
    2
    Views
    569

    Basic Question

    Hi,

    I'm quite new to c#, if possible could someone explain what the need for the following is please/

    1. An abstract class / or interface allows a user inherit the methods etc in a new class,...
  33. Replies
    4
    Views
    793

    Re: Tex stream help

    It's in the Debug folder... Thanks.
  34. Replies
    4
    Views
    793

    [RESOLVED] Tex stream help

    Hi,

    If I run the following code, where is the text file created and stored please?




    String FileName = "Test.txt";
    FileStream fs = new...
  35. Thread: Table Delete

    by gb1983
    Replies
    2
    Views
    406

    Table Delete

    Hi,

    If I delete rows from a table which contains a non-clustered index, how is the index affected during this process? E.g. Do the remaining index pointers need to be updated to reference rows...
  36. Replies
    0
    Views
    324

    Transaction Size

    Hi,

    Is there any way to determine how big the t-log should grow in comparison with the database (mdf) file?

    For example if I insert a row and my mdf file grows by 500kb, then should my...
  37. Replies
    0
    Views
    277

    Offline / Online SS2005 Database

    Hi,

    I have a database set to Bulk Logged and Online

    Will the logging revert to Full, due to the database being online? I have been told that it should be offline, although I dont believe this...
  38. Replies
    2
    Views
    458

    Re: SPID Explanation

    Thanks,
    When the article mentions 'current user process '; does this basically mean that the SPID is allocated to each user when they are performing an operation? As the deadlock I am...
  39. Replies
    2
    Views
    458

    SPID Explanation

    Hi,

    Please can someone explain exactly what is an SPID and how it works if possible please. (SQL Server 2005).

    I have an issue with deadlocking and it will help me to understand this concept...
  40. Replies
    7
    Views
    485

    Re: SQL Statement Help

    abhijit: Thanks for your input.

    Can someone please answer my original questions if possible?

    I need to know exactly where the data is coming from at the point of the Select statement.

    And...
Results 1 to 40 of 104
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width