|
|
Search
You searched for the word(s):
Showing page 81 of 133 (1,330 total posts)
< 1 second(s)
-
SELECT * FROM [HumanResources].[Department] nu
SELECT * FROM [HumanResources.Department]
-
Poate executati pe alta baza de date?
-
Din materialul citat de dumneavoastra aruncati o privire in sectiunea Implementing User-defined Data Types. Veti gasi ceva de genul:
EXEC sp_addtype movie_num, 'int', 'NOT NULL';
-
Incercati asa:
CREATE PROC dbo.DeleteCust@cust_num int = NULLASIF EXISTS (SELECT cust_num FROM rental WHERE cust_num =@cust_num)BEGINRAISERROR(50001, 10, 1)RETURNENDDELETE FROM customerWHERE cust_num = @cust_numGO
-
Alt articol pe aceeasi tema: http://www.sql-server-performance.com/sql_server_performance_audit5.asp
Awe Enabled
If you are using SQL Server 2000 Standard Edition under Windows 2000 or 2003 (any version), or are running SQL Server 2000 Enterprise Edition under Windows 2000 or 2003 Server, or if your server has less than 4GB of RAM, the ''awe ...
-
Vedeti acest articol: How to configure SQL Server to use more than 2 GB of physical memory
Use of the /PAE switch in the Boot.ini and the AWE enable option in SQL Server allows SQL Server 2000 to utilize more than 4 GB memory. Without the /PAE switch SQL Server can only utilize up to 3 GB of memory.Note To allow AWE to use the memory range ...
-
La urmatoarea intalnire a grupului (in Februarie) o sa avem un kit full de VS 2003 Professional. Daca sunteti interesat va rog sa participati la intalnire.
-
Puteti folosi SQL Agent Alerts si executa un job ca raspuns la declansarea unei alerte.
Vedeti aceasta pagina din Books Online pentru SQL Server 2000:How to define the response to an alert (Enterprise Manager)
To define the response to an alert
Expand a server group, and then expand a server.
Expand Management, and then expand SQL Server ...
-
Pentru un point in time restore aveti nevoie minim de un full backup si de toate backup-urile de transaction log de la ultimul full-backup inclusiv the tail of the log (ultimul backup de transaction log).
Aruncati o privire pe acest articol: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#ET2AE
-
DML triggers va pot ajuta in acest caz.
... 81 ...
|
|
|