Forum Replies Created

Viewing 15 posts - 61 through 75 (of 642 total)

  • RE: SPID blocking frequently

    I have used WhoIs-Active version 11..

    I found as below script frequently access in database from application, Pl. suggest me, How can escalate to application developer?

    Wait Info: (1ms)LATCH_EX [ACCESS_METHODS_DATASET_PARENT]

    CPU:...

    September 25, 2016 at 10:45 pm

    #1903012

  • RE: SPID blocking frequently

    In Extent event started session then stopped session over period of time (1 Hours), but does not captured and stored blocked process data in xel file.

    I might be...

    September 23, 2016 at 3:26 pm

    #1902934

  • RE: Question about SQL 2012 service packs and CU.

    Yes. I get all CUs 1,2,3, 4 and 5.

    Thanks for updates, I can update latest CU5 only and no need to apply all CUs 1,2,3 and 4 of SP3.

    September 23, 2016 at 2:16 pm

    #1902927

  • RE: SPID blocking frequently

    Update statistics configured thru Maintenance plan with FULL SCAN on weekly basis, so it would completed around 57 min.

    As suggested Mr. Grant, I have configured Extent Event with help...

    September 23, 2016 at 1:36 pm

    #1902916

  • RE: Missing Index Script with Create Statement

    Hi Andrew LAckenby.

    Your script is very useful for finding missing index details in database. I executed one of the busy OLTP database and outputs are 45 create index statements in...

    September 23, 2016 at 12:31 am

    #1902706

  • RE: create view with CTE SQL statement

    Dropped Existing Linked server. then view has been created & working as per Mr. ChrisM suggested and scripts.

    Thank you all..

    September 15, 2016 at 1:44 am

    #1901029

  • RE: create view with CTE SQL statement

    Yes. it is there..

    I checked - select * from sys.sysservers,

    servername and datasource as below name

    targetserver,96361

    September 14, 2016 at 7:05 am

    #1900805

  • RE: create view with CTE SQL statement

    Yes, that view is correct SQL statement.. I have created many views with CTE Select statement in non custom port just like only Linked server name.

    also SELECT query...

    September 14, 2016 at 6:49 am

    #1900795

  • RE: create view with CTE SQL statement

    Remoteserver_Name -> target server which is created linked server

    Port Number-> 96361 - this is custom port number was mentioned in target server at SQL 2012

    SELECT *

    FROM OPENQUERY (

    [Remoteserver_Name,96361],

    September 14, 2016 at 5:45 am

    #1900768

  • RE: Query output not display in HTML format

    I have changed in second table as below..

    SET @body1 ='<html><body></table><H3>ROAD Users</H3>

    Thanks a lot Ed Wagner .. Perfectly working as you suggested.. Thank you.

    August 27, 2016 at 2:34 pm

    #1897966

  • RE: Query output not display in HTML format

    Thanks Ed Wagner.. As per your suggestion results are coming email body two different table format after changed as below coding.

    But second table heading joined with last row of...

    August 27, 2016 at 1:01 pm

    #1897960

  • RE: Query output not display in HTML format

    Pl. find the attached email which is receiving in Email body.. there are two different query that two query output display in email body with line brake separately with heading.

    August 26, 2016 at 9:23 am

    #1897845

  • RE: Query output not display in HTML format

    as per above script both heading are merged in single HTML report.

    I want two different HTML report in same email body. Pl give some example HTML script.

    Thanks

    August 26, 2016 at 7:59 am

    #1897802

  • RE: Query output not display in HTML format

    HTML Heading not coming separately in same email report... both heading merged with in single report.

    Thanks

    August 26, 2016 at 7:12 am

    #1897784

  • RE: Query output not display in HTML format

    First and Second query Result set merged with in single HTML report format. but it is not display separately in email body...

    August 26, 2016 at 1:17 am

    #1897713

Viewing 15 posts - 61 through 75 (of 642 total)