remidian

Can't find what you're looking for? Use of one of the search websites below …

Home → Page 3

pipe

man: NAME: pipe – create an interprocess channel import from compressed export file Example below demonstrates …

  • / *nix
  • # 1188
  • FEB, 7 2007

Configure telnet

Install and configure telnet on fresh Debian install Install (download) telnet Install telnet with the apt-get utility …

net use: map network share

To map a network share issue command below: Define a network share net use <drive>: \\\\<servername>\\<directoryname> /user:<domain>\\<username> …

Create, drop and rename a database

Create, rename and drop a database in sql server … Create database See syntax below for the …

  • / T-SQL
  • # 1048
  • NOV, 15 2006

Control Structures

Control structures syntax; IF THEN ELSE, CASE, …

Use filters to keep your traces meaningfull

Say you have an sql trace for the event ‘TSQL SQL:StmtCompleted’ you are, most probably, …

  • / T-SQL
  • # 7043
  • NOV, 3 2006

cursors in tsql

Cursors in tsql, it can be done … Simple cursor loop Example below is the most …

  • / T-SQL
  • # 2155
  • NOV, 1 2006

return variables from dynamic sql – sp_executesql

Returing values into tsql variables from a dynamic sql statement using sp_executesql …

  • / T-SQL
  • # 808
  • SEP, 18 2006

environment

Getting around in the mssql environment Whoami In MSSQL (2000) there’s not an easy way to see …

Date Time functions

Date time functions (frustrations) in T-SQL. Current date Functions getdate and …

MSSQL cheat sheet for the Oracle minded

A translation of oracle dba_* tables/v$* views/functions to their respective mssql counterparts. dba_* tables Oracle Table/View MSSQL Table/View Note dba_data_files …

SQL Trace Reference

Display/Alter running traces or an alternative way to shutdown your server (when ‘c2 audit mode’ …

sp_configure

Display or change global configuration settings for your mssql server through sp_configure. Show (advanced) configuration options To …

find

man: NAME: find – find files Find/Remove old files Find files modified more then 365 days …

  • / 10g
  • # 2571
  • AUG, 30 2006

Invalidated synonyms

In Oracle 10G synonyms are marked invalid when you perform DDL on the referenced object. …

overcome SP2-0734 when using purge command

Issue new Oracle 10G ‘purge‘ command results in ‘SP2-0734: unknown command beginning “purge user…” – …

To trace or not to trace

Oracle Trace reference g-se-tr.sql Script below enables trace in another user session. It will list all three …

  • / 10g
  • # 1645
  • JUL, 2 2006

Automatic Workload Repository

A very short howto for the ‘Automatic Workload Repository’, the successor of perfstat. Interval Some queries; Listing …

dba$log_blocker

Code below will save the information of the ‘blocking session’ in an ORA-00060 situation. Since …