Marcello Miorelli jjradha
jjradha
/ the_trigger_creation.xml
Created
June 16, 2022 20:13
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <Krishna>IF 'my_server' <> @@ServerName THROW 50001, 'Wrong Server!!!',1 </Krishna> | |
| <Krishna>GO</Krishna> | |
| <Krishna>use [DB_02]</Krishna> | |
| <Krishna>GO</Krishna> | |
| <Krishna>IF EXISTS (SELECT 'Radhe' FROM sys.triggers t wHERE t.[name] = 'tgr_repl_AuPair_Insert' AND CASE WHEN t.parent_id = 0 THEN t.parent_id ELSE object_id('[sub].[repl_Aupair]') END = t.parent_id ) | |
| </Krishna> | |
| <Krishna>EXEC('BEGIN DROP TRIGGER [sub].[tgr_repl_AuPair_Insert] END') </Krishna> | |
| <Krishna>GO</Krishna> | |
| <Krishna></Krishna> | |
| <Krishna>CREATE TRIGGER [sub].[tgr_repl_AuPair_Insert]</Krishna> |
jjradha
/ results from dbcc for test1
Created
October 29, 2018 20:17
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DBCC results for 'test1'. | |
| Service Broker Msg 9675, State 1: Message Types analyzed: 14. | |
| Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. | |
| Service Broker Msg 9667, State 1: Services analyzed: 3. | |
| Service Broker Msg 9668, State 1: Service Queues analyzed: 3. | |
| Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. | |
| Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. | |
| Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. | |
| Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0. | |
| DBCC results for 'sys.sysrscols'. |
jjradha
/ the result of sp_blitz
Created
October 29, 2018 19:56
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| **Priority 10: Performance**: | |
| - DBCC SHRINK% Ran Recently - The user MMiorelli has run file shrinks 2 times between Oct 29 2018 7:51PM and Oct 29 2018 7:51PM. So, uh, are they trying cause bad performance on purpose? | |
| **Priority 50: DBCC Events**: | |
| - Overall Events - 2 DBCC events have taken place between Oct 29 2018 7:51PM and Oct 29 2018 7:51PM. This does not include CHECKDB and other usually benign DBCC events. |
jjradha
/ PROCEDURE [repl].[usp_upd_repl_out_application]
Created
March 5, 2018 14:36
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ALTER PROCEDURE [repl].[usp_upd_repl_out_application] | |
| ( | |
| @applicationId int | |
| ) | |
| AS | |
| BEGIN | |
| BEGIN TRAN | |
| BEGIN TRY |
jjradha
/ gist:33da769204e5855bcc92ccab68f114b8
Created
June 16, 2017 06:28
the error log while tring to connect using teamviewer - Connection to 419600239 denied, because remote TeamViewer is not visible
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2017/06/16 07:20:57.826 4204 4208 S0 SERVICE_CONTROL_SESSIONCHANGE session=1, statusCode=WTS_SESSION_UNLOCK | |
| 2017/06/16 07:21:02.608 4204 5052 S0 CAcceptServer::HandleAccept: new connection from 127.0.0.1:51961 | |
| 2017/06/16 07:21:02.608 4204 5052 S0 TerminalServer: ProcessConnected PID 6596 user session 1 process type 2 | |
| 2017/06/16 07:21:02.623 4204 5052 S0 CInterProcessNetwork::SetDyngateIDforSession() id=420038999 session=1 ptype=2 | |
| 2017/06/16 07:21:02.623 4204 5052 S0 UpdateOnlineState newOnlineValue 1 | |
| 2017/06/16 07:21:02.623 4204 8640 S0 TeamViewer is going online! | |
| 2017/06/16 07:21:02.623 4204 5064 S0 CKeepAliveClientClient::DoReconnectInternal: doing nothing, state = 0 | |
| 2017/06/16 07:21:02.623 4204 5060 S0 Activating Router carrier | |
| 2017/06/16 07:21:02.154 6596 652 G1 Logger started. | |
| 2017/06/16 07:21:02.154 6596 652 G1 StringCompare locale: Italian_Italy.1252 |
jjradha
/ the query plan - PROCEDURE [Bocss2].[upGetReturnDetails]
Created
December 1, 2016 14:58
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="utf-16"?> | |
| <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.3.1" Build="12.0.5000.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="3" StatementEstRows="2.55412" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="120" StatementSubTreeCost="7.96175" StatementText="SELECT o.strBxOrderNo,
 i.sintOrderSeqNo,
 r.decReturnGoodsNetAmount,
 r.decReturnGoodsTaxAmount,
 r.decReturnShippingNetAmount,
 r.decReturnShippingTaxAmount,
 r.decReturnTotalAmount,
 r.decBCReturnGoodsNetAmount,
 r.decBCReturnGoodsTaxAmount,
 r.decBCReturnShippingNetAmount,
 r.decBCReturnShippingTaxAmount,
 r.decBCReturnTotalAmount,
 r.blnManual,
 r.bl |
jjradha
/ gist:2596ec42bbb4d3d5e8e7618797007e25
Created
October 20, 2016 16:53
warning on the sort operator
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="utf-16"?> | |
| <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.3.1" Build="12.0.5000.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="3" StatementEstRows="1.4925" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.0285251" StatementText="SELECT DISTINCT
 a.strAccountCode ,
 a.strAddressLine6 ,
 a.strPostalCode ,
 CASE WHEN a.strCountryCode IN ('91','92') THEN 'GB-Int'
 ELSE a.strCountryCode
 END AS [strCountryCode]
 FROM Bocss2.dbo.tblBAccountParticipant AS ap
 INNER JOIN Bocss2.dbo.tblBAccountParticipantAddress AS apa ON ap.lngParticipantID = apa.lngParticipantID
 AND apa.sintAdd |
jjradha
/ italian_cities.xml
Created
September 14, 2016 09:54
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="utf-16"?> | |
| <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="12.0.2000.8" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="1" StatementEstRows="15" StatementId="1" StatementOptmLevel="TRIVIAL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="0.0032985" StatementText="select [name] from italian_cities
order by [name] desc" StatementType="SELECT" QueryHash="0xDAAE8C127A4785E4" QueryPlanHash="0xB60E0157D0A84290" RetrievedFromCache="true"> | |
| <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" /> | |
| <QueryPlan DegreeOfParallelism="1" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="88"> | |
| <MemoryGrantInfo SerialReq |
jjradha
/ XML is empty = how to check in sql server
Created
August 19, 2016 15:42
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="utf-16"?> | |
| <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="12.0.2000.8" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="7" StatementEstRows="1000070" StatementId="1" StatementOptmLevel="FULL" CardinalityEstimationModelVersion="120" StatementSubTreeCost="24.5016" StatementText="select t.*
from RADHE_01 t
where t.MYXML.exist('*') = 0 OR t.MYXML IS NULL" StatementType="SELECT" QueryHash="0x78CFEF157D3D2516" QueryPlanHash="0x831670FA8C31EE5A" RetrievedFromCache="true"> | |
| <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" /> | |
| <QueryPlan DegreeOfParallelism="1" CachedPlanSize="24" CompileTime="1" CompileCPU="1" CompileMemory="312"> | |
jjradha
/ udpProductTaxRateGet NEW
Created
August 12, 2016 10:14
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="utf-16"?> | |
| <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="12.0.2000.8" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan"> | |
| <BatchSequence> | |
| <Batch> | |
| <Statements> | |
| <StmtSimple StatementCompId="10" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.00657344" StatementText="SELECT TOP 1 ISNULL(pst.TaxCode, '') as TaxCode
 , ISNULL(pst.TaxRate, 0) as TaxRate
FROM dbo.[ProductShipTax] pst
WHERE EXISTS (

 SELECT TaxRegionId
 FROM dbo.[ShipTaxAddress]
 WHERE [CountryCode] = @countryCode
 AND [AddressFormatID] = @addressFormatID

 AND ([MatchAddressLine1] = @AddressLine1 OR ([MatchAddressLine1] IS NULL AND @AddressLine1 IS NULL) )& |
NewerOlder