Where do you think the users names and passwords will be stored in sql server?
They get stored in master db in the sysxlogins table. Read more »
Archive for June, 2006
What is an Index?
When queries are run against a db, an index on that db basically helps in the way the data is sorted to process the query for faster and data retrievals are much... Read more »
What’s the difference between a primary key and a unique key?
Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where... Read more »
What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.
Dropping : (Table structure + Data are deleted), Invalidates the dependent objects ,Drops the indexes Truncating: (Data alone deleted), Performs an automatic... Read more »
How can you compare a part of the name rather than the entire name?
SELECT * FROM people WHERE empname LIKE ‘%ab%’ Would return a recordset with records consisting empname the sequence ‘ab’ in empname Read more »
Design Goals Of a Computer Architecture
Design goals The most common goals in computer architecture revolve around the tradeoffs between cost and performance (i.e. speed), although other considerations,... Read more »
What are I/O Interrupts?
I/O Interrupt °An I/O interrupt is just like the exceptions except: • An I/O interrupt is asynchronous • Further information needs to be conveyed °An I/O interrupt... Read more »
How I/O devices notifies the Operating System
I/O Device Notifying the OS °The OS needs to know when: • The I/O device has completed an operation • The I/O operation has encountered an error °This can... Read more »
Commands to I/O Devices !
Giving Commands to I/O Devices °Two methods are used to address the device: • Special I/O instructions • Memory-mapped I/O °Special I/O instructions specify: •... Read more »
What are Pipelining Issues?
Pipelining increases the CPU instruction throughput - the number of instructions completed per unit of time. But it does not reduce the execution time of an individual... Read more »