Fandom

Scratchpad

Tech Tips

215,640pages on
this wiki
Add New Page
Discuss this page0 Share

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.

  1. !perl -w


if ( $#ARGV == 2 )

{

print "$ARGV[0]\n";

print "$ARGV[1]\n";

print "$ARGV[2]\n";

}

else { die ( "Usage :: perl qsplit.sql <queryfile> <inputfile> <splitrows> \n" );

}


my $queryfile = $ARGV[0];

my $inputlist = $ARGV[1];

my $splitcount = $ARGV[2];

my $outputfile = "qout.txt";

open ( QRY, "$queryfile" ) || die "Can Not open $queryfile :$!\n";

open ( INPT, "< $inputlist" ) || die "Can Not open $inputlist :$!\n";

open ( OUT, "> $outputfile" ) || die "Can Not open $outputfile :$!\n";

my $rowcount = 0;

my @query=<QRY>;

print "Query : @query\n";


while ( <INPT> ) { $rowcount++;

if ( $rowcount == 1 ) {

 print OUT "@query" . $_;

} elsif ( ($rowcount % $splitcount ) == 0 ) {

 s/,/ ) UNION @query /g;
  print OUT $_;

} else {

print OUT $_;

} }

print OUT ")";


perl -lane "s/^/UNION select * from table where id in ( /g if $.%1000==0;print $_" my.txt > fmt.txt


perl -lane "s/,$/)/g if (($.%1000)-999)==0;print $_" fmt.txt > fmt.txt



bcp tempdb..plus_change in plus_change.txt -c -b200 -t -S<server> -U user -P password






details of column

SELECT

COLUMN_NAME,data_type,character_maximum_length from information_schema.columns WHERE TABLE_NAME = 'referral'





Table from coulmn

SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name =





sp_helpsegment logsegment



select * from master..sysprocesses where spid in (select blocked from master..sysprocesses where blocked > 0)





sp_dba_w active – for blocking proces




sp_dba_lock – for locks




price..sp_space total – space usage.






sp_lock - The class column will display the cursor name for locks associated with a cursor for the current user and the cursor id for other users.








select * from syslogshold where spid > 0




sp_who'576'






sp_showplan 576,null,null,null






dbcc sqltext() you can also use this command to get see whats is happening in a block you can do this by

use master go select * from syslogshold this will find the longest running transaction. go dbcc traceon(3604) go dbcc sqltext (104) go


Incident Summary:

Incident Timeline Summary:

Minutes of the Post Mortem Meeting:

Root Cause:

Resolution:

Was the best resolution chosen?

How can future similar incidents be avoided?

Can RTB improve handling of the incident?

Action Points: 'Attendees:

Also on Fandom

Random wikia