|
|
Search
You searched for the word(s):
Showing page 21 of 68 (674 total posts)
< 1 second(s)
-
-
Vezi si
http://weblogs.sqlteam.com/mladenp/archive/2007/07/30/60273.aspx
-
Uite si o sursa de inspiratie:
http://www.sqlservercentral.com/articles/Audit/67431/
-
In SQL 2005 cam trebuie sa-ti construiesti procedurile de audit ''din bucati'' - folosesti SQL profiler, triggeri DDL / DML / logon, log-uri de aplicatie...
Exista ''C2 audit mode'', dar nu cred ca ai nevoie de asa ceva...
Daca vrei un mediu de audit unitar si mai eficient, treci pe SQL 2008...
-
Vezi http://sqlserver.ro/forums/1/7154/ShowThread.aspx
-
Vezi daca te ajuta si
http://www.sommarskog.se/dyn-search-2005.html
-
E bine sa verifici fiecare caz in parte.
Daca, de exemplu, rulez scriptul de mai jos la mine (Vista Business 32 biti SP1, 4 CPU 2.8 Ghz, 2GB RAM, SQL 2008 dev SP1) obtin 1026 ms in cazul variabilei tabel si 596 ms in cazul tabelului temporar. Scriptul este propus de Gail Shaw (http://sqlinthewild.co.za/):
Use AdventureWorks2008
go
-- Table ...
-
Vezi daca te ajuta
http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx
Eu lucrez deocamdata pe Vista Business SP1. Folosesc SQL 2005 dev SP2 si SQL 2008 dev SP1.
-
Vezi si
http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/
-
Vezi daca te ajuta si BOL ---> Inserting data from an OUTPUT Clause into a target table
... 21 ...
|
|
|