h1

Jobs in sql server, sql server agent si excludere mutuala

September 1, 2012

Excluderea mutuala in OS: un set de proceduri care permit interactiunea cu o resursa comuna.

Job in Sql Server – este o colectie de pasi executata de motorul bazei de date/database engine

Sql Server Agent -> serviciu ce gestioneaza joburile in Sql Server-> este un serviciu Microsoft care il gasiti in start->run->type services.msc ce executa task-uri administrative programate care se numesc joburi.

Advertisements
h1

Clauza REFERENCES, FOREIGN KEY

March 12, 2011

h1

Free download SQL Server 2008 R22

February 10, 2011

http://technet.microsoft.com/en-us/evalcenter/ee315247


h1

Cap24. Mssql proceduri stocate built-in

March 29, 2010

1) Procedurile stocate sp_addtype si sp_droptype

2) Procedurile stocate sp_help si sp_helptext

3) Procedurile stocate sp_depends si sp_helpconstraint

4) Procedura stocata sp_key (PRIMARY KEY):

5) Procedura stocata sp_fkeys

6) Procedura sp_helpdb (afiseaza marimea si locatia fisierelor din bd) si procedura stocata sp_spaceused

7) Procedura stocata sp_helptrigger -afiseaza informatii despre triggeri

8) Procedura stocata sp_who si kill

9) Procedura stocata sp_lock (afiseaza informatii despre locks din bd)

10) Procedurile stocate sp_password si sp_addlogin:

sp_addlogin si alte proc.stocate:

h1

Cap23. Interogari si sub-interogari avansate,tabele temporare,intersectia a 2 tabele, diferenta a 2 tabele

March 28, 2010

1) Self join (multy-query table that refers to itself):

2) Tabele temporare pt. inlaturarea datelor duplicate

Stergere inregistrari din tabela temporara:

3) Setare valori tabela 1 bazat pe valori din tabela 2 (clauza UPDATE):

4) Operatorii IN si EXISTS (IN verifica daca o valoare e intr-o lista de valori)

5) Operatorul ALL pt.a combina 2 query-uri intr-una singura

6) Operatorul EXISTS pt.a verifica daca exista inregistrari duplicat in tabela

7) Join la continutul tabelelor si rezultatele functiilor (chestionar msssql)

8) Folosire view-uri pt.a vedea ierarhia  nivelurilor de agregare

9) Predicatul EXISTS pt. a afisa intersectia a 2 tabele

10) Predicatul EXCEPT pt.a afisa diferenta dintre 2 tabele

11) Clauza TOP

12) SELECT cu RUNNING TOTALS

h1

Cap.20 Proceduri stocate ,functii utlizator

March 28, 2010

1) Sintaxa generala proceduri stocate  (ex.proc.stocata si executie proc stocata)

2)  Cum se definesc variabile intr-o procedura stocata

3) Folosire proceduri stocate pt.a intoarce valori

4) Intoarcerea unei valori dintr-o functie  stocata folosind cuv.cheie RETURN:

5) Lucrul cu cursori in procedurile stocate

6) Declararea variabilelor intr-o procedura stocata si asignarea valorilor pt.aceste valori declarate (clauzele declare si set):

7) Crearea unei functii utilizator (CREATE FUNCTION-crearea functiilor scalare in mssql)

Explicatia parametrilor:

Exemple CREATE FUNCTION:

Ex1:

Ex2:

Ex3:

8) Stergerea unei proceduri stocate sau functii utilizator (functii scalare)

h1

Cap19. Lucru cu information schema view

March 25, 2010

Totul despre tabele sistem:

Creare mdf si ldf fisiere:

Adaugare fisiere si grupuri fisiere la bd existente:

Arhitectura single respectiv multi pt.bd

In a single-database architecture (such as that used by a DB2 or ORACLE SQL Server), the DBMS supports (and manages) a single database. (The database may consist of multiple physical files, but all database objects exist in a single logical database file.)

Multi-server:

A multi-database architecture, as shown in Figure 498.2, lets you group tables (by owner) within multiple database files. Instead of keeping tables for multiple applications in the same database file (as is the case in a single-database architecture), each database will normally support a single (or set of related) applications. When you add a new, different application, you will typically create a new database to hold that tables used to support it.

Raport vanzari mssql:

1) Schema check constraints view

2) Folosire COLUMN_DOMAIN

3) Schema COLUMN_PRIVILEGES

4) Schema column views

5) Schema CONSTRAINT_COLUMN_USAGE

6) Schema CONSTRAINT_TABLE_USAGE

7) Schema DOMAIN_CONSTRAINTS

8) Schema DOMAIN

9) Schema KEY_COLUMN_USAGE

10) Schema PARAMETERS

11) Schema REFERENTIAL_CONSTRAINTS

12) Schema ROUTINES

13) Schema SCHEMATA

14) Schema Table_Constraints

15) Schema Table_Privileges

16) Schema tables

17) Schema VIEW_COLUMN_USAGE

18) Schema VIEW_TABLE_USAGE

19) Schema ROUTINE_COLUMNS

20) Schema VIEWS View