|
|
Search
You searched for the word(s):
Showing page 126 of 133 (1,330 total posts)
< 1 second(s)
-
You want to create a stored procedure that will access a remote SQL Server named TestSrv.You add the TestSrv as a linked server using the following code:USE master;
GO
EXEC sp_addlinkedserver
'TestSrv',
N'SQL Server'
GO
You want to select data using the local stored procedure from the Sales.SalesOrderDetails table located in the ...
-
This is a must see white paper written by Robert Dorr !
I won't say more but if you are a serious dba then you've got to read this:
SQL Server I/O Basics, Chapter 2
-
Script Repository: SQL Server 2005
If you follow the above link you will find scripts that will help you manage your SQL Server. To give you an idea of what you can get from this site I included the list of topics:Buffer CacheCPU and OptimizationIndexes and IndexingInput/OutputPerformance (General)Processor CacheSQL ...
-
Este exact subiectul prezentarii mele !
Principals, Securables, Permissions si Execution Context !
-
The English version here: http://sqlserver.ro/forums/thread/190.aspx
Pe 28 Octombrie 2006 ora 10:45 va avea loc o intalnire dedicata SQL Server la sediul Microsoft Romania.
Vor fi 50 de locuri, premii (carti, mousi etc.) si 3 ore (nu garantam ca doar atat) de SQL si de distractie.
Pana atunci insa va rugam sa ne spuneti ce subiecte sa abordam ...
-
-
This document is inteded to server as a review tool for 70-431.I will add information each day and you are invited to post any suggestions or comments.
List of Objectives
Installing and Configuring SQL Server 2005
Install SQL Server 2005.
Verify prerequisites.
Upgrade from an earlier version of SQL Server.
Create an instance. ...
-
SQL Server 2005 introduce modelul TRY/CATCH pentru tratarea erorilor. Folosirea acestuia este similara cu folosirea in alte limbaje de programare ca C++ sau C#.
Sintaxa:
BEGIN TRY
{ sql_statement | statement_block }
END TRY
BEGIN CATCH
{ sql_statement | statement_block }
END CATCH
[ ...
-
What statement allows you to rebuild, reorganize, disable or enable an index in SQL Server 2005 ?
Place the mouse cursor HERE for the answer
Reference: http://msdn2.microsoft.com/en-us/library/ms188388.aspx
-
Searching some documentation about SQL Server 2005 architecture I discovered this site:
http://www.microsoft.com/india/teched2006/presentations.aspx
Some of the sesions that I consider to be very interesting are:
SQL Server Monitoring Tools: The Key to Running 24x7 SQL
SQL Internals: Core Database Engine Changes in SQL Server ...
... 126 ...
|
|
|