Forum Replies Created

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

  • RE: How to receive Deadlock information automatically via email.

    The same error repeated after removed quotes on both side..

    @query = 'select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like ''%Deadlock...

    November 3, 2016 at 6:28 am

    #1910326

  • RE: How to receive Deadlock information automatically via email.

    Thanks Tony for your reply, I have tried and modified on existing script for file attachment as below, but its throwing errors

    Please help.

    declare @subject varchar(250)

    select @subject = 'Deadlock reported on...

    November 2, 2016 at 10:30 pm

    #1910271

  • RE: How to receive Deadlock information automatically via email.

    Hi.. it is very useful script for monitoring deadlock event occur in OLTP databases.

    I am facing same issues: But when deadlock occurred i received attachment in text file but...

    November 2, 2016 at 4:53 am

    #1910057

  • RE: Disaster Recovery

    Hi,

    I would like share the AG setup.

    I recently deployed alwayson availability group one of the OLTP database for DR requirment with MultiSubNet failover.

    OS: Win 2012 R2 standard edition, DB: SQL...

    October 27, 2016 at 10:59 pm

    #1909283

  • RE: SPID blocking frequently

    Hi SQL GURU and Jeff,

    Issues resolved by developer, he has changed and modified the existing whole query at application side. After that there is no glitch and blocking...

    September 27, 2016 at 7:33 am

    #1903332

  • 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

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