Sql server
- Can you explain how to persist objects, permissions in
tempdb? - March 31, 2010 at 19:10 PM by Vidya Sagar
Can you explain how to persist objects, permissions in
tempdb?
The tempdb gets created every time
when the SQL Server service restarts.
To persist objects and permissions,
first step is to create a new procedure which creates the required objects in
tempdb. Mark this procedure as a startup procedure, in order to run every time
when SQL Server starts.
By using “sp_procoopton”, a system
procedure, set the startup option. This will automatically create procedure and
runs, when the SQL Server is restarted. The syntax of sp_procoption is
sp_procoption @proc_name,
@optionName, @optionValue
where
@proc_name is the name of the procedure
@optionName is StartUp
@optionValue is True.
Failover clustering is mainly used for data availability. Typically in a
failover cluster, there are two machines. One machine provides the basic
services and the second is available to run...................
A linked server allows remote access. Using this, we can issue distributed
queries, update, commands, and transactions across different data
sources................
Page splits are performed when there is no space in a data page to accommodate
more inserts or updates. In a page spilt, SQL server removes some data from the
current data page and moves it to another data page...............
EXCEPT clause is used to return records that are returned by the first query and
NOT the second query................
|