Latest Answer: bigint can hold values from -2^63 (-9,223,372,036,854,775,807) to 2^63-1 (9,223,372,036,854,775,807) and it takes 8 bytesint can hold values from -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647) and it takes 4 bytes ...
Latest Answer: DTS is a set of tools you can use to import, export, and transform heterogeneous data between one or more data sources, such as Microsoft SQL Server, Microsoft Excel, or Microsoft Access.The Import/Export Wizard is for building relatively simple DTS packages, ...
Latest Answer: Yes, coming to your answer clustered index is used and applied only and primary keysFor example if a table student is created consider here in this table student id is the primary key so clustered index is applied on the student id column.Coming to non-clustered ...
Latest Answer: User Identification: In virtue of Data base server Identification tries to
find whether you are registered user in the database or not. It applies to whole
database server.
Authentication: It applies for special Privileges for a user in the database. ...
Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform a full database backup. You decide to implement the following backup strategy : Full backup : 9am SundayFile 1 backup : 8pm Monday eveningFile 2 backup : 8pm Tuesday eveningFile 3 backup : 8pm Wednesday eveningFile 1 backup : 8pm Thursday eveningFile 2 backup : 8pm Friday eveningFile 3 backup : 8pm Saturday eveningTransaction log backups : Hourly, every day.DB suffers critical failure
Latest Answer: select * from sysobjects where xtype='U' ...
Latest Answer: Dirty Pages: Data that has been modified and Stored in the buffer cache and has not yet been written in to the hard disk. (Transaction Logs)Dirty reads: Reading the data that is actually read by Transaction2 which was modified by Transaction 1 and Transaction1 ...
Latest Answer: use IsNULL(,value) .If query return null ,it will replace by value. ...
Latest Answer: exec sp_rename 'tablename.columnname','newcolumnname' ...
Latest Answer: Deadlock occurs when two or more processes have lock objects and each process is trying to acquire a lock on an object that the other processes have previously locked. Let p1 process has an exclusive lock on object o1, p2 process has an exclusive ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
