Learn Database: Sql Server

Topics: All about Sql Server'

Browse all answers:

What is Sql server?
What are the System Database in Sql server 2005?
What is the difference between SET and SELECT?
What is the difference between char , varchar and nvarchar?
How many types of triggers are there?
Which TCP/IP port does SQL Server run on? How can it be changed?
What are the System Database in Sql server 2008?
What are different types of normalization
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is Public Role in SQL Server?
Can SQL Servers linked to other servers like Oracle?
What is denormalization and when would you go for it?
What are the different types of Sub-Queries?
What are constraints? Explain different types of constraints?
What is the STUFF function and how does it differ from the REPLACE function?
Which command using Query Analyzer will give you the version of SQL server and operating system?
What are the different types of BACKUPs avaialabe in SQL Server 2005?
What is SQL Server Agent?
 Name 3 ways to get an accurate count of the number of records in a table?
Define Primary Key?
What is cursors? and what are the different types of cursor?
Explain SQL Server Management Studio (SSMS)?
What is SQL Profiler?
What is SQL Server Agent?
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
What mode of authentication does SQL Server NOT provide?
What is an active database?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What are the purpose of Normalisation?
Explain how to make remote connection in database  
What is Replication?
What are the types of Replication?  
Define the terms used in Replication?
Explain the concepts of faster differential backups.
Explain the concepts of Parallel Database consistency check (DBCC)?
Define Indexed view.
The strictest transaction isolation level provided by SQL Server is called?
What is built-in function? Explain its type i.e. Rowset, Aggregate and scalar. ?
What are the benefits of User-Defined Functions?  
How do you maintain a fill factor in existing indexes?  
What are different Types of Join?
Explain Nested Join, Hash Join and Merge Join in SQL query plan.  
Define Table.
Define Local temporary table and global temporary table.
Define SQL Server Tables. Explain Create Table syntax with an example.
What is sub-query? Explain properties of sub-query.
Explain with examples for the Subqueries with IN and NOT IN.  
Explain the subqueries with comparison operators?
Explain with examples for the Subqueries with Exists and NOT Exists?
Brief about Insert Statement with an example?
Brief about Select….into statement with an example.  
Describe how bcp command prompt utility is used to import and export data?
Define distributed queries.  
Explain how to use Cube operator to summarize data?
Brief about Insert Statement with an example?
How will you copy the structure of a table without copying the data? 
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no. 
Which RAID levels store parity information? 
Where does Profiler store its temporary data in SQL Server 2005? 
Explain about SQL server 2005? 
What is DESCRIBE command in SQL Server?What is its purpose?How to use it? 
What is the difference between weak entity set & strong entity set? 
Explain about the command line tool SQLCMD? 
What is updatable view & non updatable view ?
How functional dependency is related to database table design? 
Detail about query optimizer? 
Detail about the hardware which is supported by SQL server? 
What does the Queue Reader Agent do in SQL Server 2005 replication? 
Explain about integration services of Microsoft SQL server? 
What does this return select (1324 & 1024)? 
Which of the following modules within SQL Server 2005 cannot be signed with a digital signature? 
What does the DEALLOCATE statement do in SQL Server 2005? 
Explain about thread and memory management process of SQL? 
What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005? 
Explain about integration services of Microsoft SQL server? 
Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report? 
Explain about analysis services? 
What is the difference between sql server,database server and oracle server? 
What are data objects? 
What does this return?declare @i intselect @i = -5select +@i 
Explain in brief about Microsoft SQL server? 
Clicking File, Save in Report Builder does which of the following? 
Where does Profiler store its temporary data in SQL Server 2005? 
What does @@textsize return? 
How To Verify the Port Number of the SQL Server? 
What is table in SQL server? What is ##table in SQL server? 
Which types of replication work with Oracle publishers? 
What Are Security Principals Used in SQL Server 2005? 
How To Loop through Result Set Objects using odbc_fetch_row()? 
What is different between int and bint? 
How To Enter Unicode Character String Literals in MS SQL Server? 
How can i install a sql server software in a pc? 
How to rename databases in MS SQL Server?
Explain about merge replications? 
What is the query used to display all tables names in SQL Server (Query analyzer)? 
How to split a string using using SQL Server. 
How a sql server is been used in our programs?
How do you optimize stored procedures ? 
How to remove duplicate records from a table? 
How To Create a Large Table with Random Data for Index Testing in MS SQL Server? 
How To Defragment Table Indexes? 
What Are Logical/Boolean Operations in MS SQL Server? 
How To Change a Login Name in MS SQL Server? 
How Extra Digits Are Handled with NUMERIC Data Type Literals? 
Give some examples of Analytical functions? 
How many rows are returned by these two select statements? 
How Extra Digits Are Handled with NUMERIC Data Type Literals? 
How To Defragment Table Indexes? 
How To Create a Testing Table with Test Data in MS SQL Server? 
What Is Index Fragmentation in MS SQL Server? 
What Happens If the UPDATE Subquery Returns No Rows in MS SQL Server? 
Name of the class of SQL? 
How to install SQL Server 2005 Express Edition? 
How To Get a List of All Tables with "sys.tables" View in MS SQL Server? 
How To Connect to a SQL Server using odbc_connect()? 
How To Add a New Column to an Existing Table with "ALTER TABLE ... ADD" in MS SQL Server? 
How to rename an existing table with the "sp_rename" stored procedure in MS SQL Server?
How To Receive Returning Result from a Query? 
How To Use Column Default Values in INSERT Statements in MS SQL Server? 
How To Delete All Rows with TRUNCATE TABLE Statement in MS SQL Server? 
How To Write a Query with a Left Outer Join in MS SQL Server? 
What Are Binary String Data Types in MS SQL Server? 
What Are Unicode Character String Data Types in MS SQL Server? 
How To Use Group Functions in the SELECT Clause in MS SQL Server? 
How To Specify the Collation for a Character Data Type in MS SQL Server? 
How Fixed Length Strings Are Truncated and Padded? 
What Are the Differences between CHAR and NCHAR in MS SQL Server? 
What Are the Differences between DECIMAL and FLOAT in MS SQL Server? 
How To Find Out What Is the Default Collation in a Database? 
The default collation of a database comes from the server if you are not using the COLLATE clause in the CREATE DATABASE statement. If you are not using the COLLATE clause for character string column, it will use the default collation from the database. Using this logic, you can find out the default collation in a database or server very easily. See the following tutorial exercise:CREATE DATABASE GlobalGuideLineDatabaseGOCREATE TABLE faq (Name VARCHAR(80))GOSP_HELP FAQGOColumn_name ... CollationName ... SQL_Latin1_General_CP1_CI_ASNow we know that the default collation for SQL Server 2005 is SQL_Latin1_General_CP1_CI_AS.
How To Convert Numeric Expression Data Types using the CAST() Function? 
How To Skip Remaining Statements in a Loop Block Using CONTINUE Statements? 
Is the PRIMARY KEY Column of a Table an Index in MS SQL Server? 
How To End a Stored Procedure Properly in MS SQL Server? 
How To Define Output Parameters in Stored Procedures? 
How To Receive Output Values from Stored Procedures? 
How To Rebuild Indexes with ALTER INDEX ... REBUILD? 
How To Execute the Cursor Queries with "OPEN" Statements? 
How To Change the Name of a Database User? 
How to set a database state to OFFLINE in MS SQL Server? 
What is a database table? 
How To Update Values in a Table with UPDATE Statements in MS SQL Server? 
How To Use Values from Other Tables in UPDATE Statements in MS SQL Server? 
How to provide column names in INSERT Statements in MS SQL Server? 
What Are DML (Data Manipulation Language) Statements in MS SQL Server? 
How To Join Two Tables in a Single Query in MS SQL Server? 
How To Name Query Output Columns in MS SQL Server? 
Can Multiple Columns Be Used in SQL GROUP BY Clause in MS SQL Server? 
What Is SQL Language? 
How To Start and End Transact-SQL Statements? 
What Are Character String Data Types in MS SQL Server? 
How Many Categories of Data Types Used by SQL Server? 
What Are the Differences between DECIMAL and FLOAT in MS SQL Server? 
How To Create User Messages with PRINT Statements in MS SQL Server? 
How To Write Character String Constants or Literals in MS SQL Server? 
What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? 
How To Enter Unicode Character String Literals in MS SQL Server? 
What Are the Differences between CHAR and VARCHAR in MS SQL Server? 
How To Enter Binary String Literals in MS SQL Server? 
What Are the Underflow and Overflow Behaviors on FLOAT Literals?
What Happens If an Integer Is Too Big for INT Date Type? 
How To Generate Random Numbers with the RAND() Function in MS SQL Server? 
What Are the Mathematical Functions Supported by SQL Server 2005? 
What To Perform Pattern Match with the LIKE Operator? 
How To Execute a Stored Procedure in MS SQL Server? 
How To Bind a View to the Schema of the Underlying Tables? 
How To Use Wildcard Characters in LIKE Operations in MS SQL Server? 
How To Use "IF ... ELSE IF ... ELSE ..." Statement Structures in MS SQL Server? 
How To Get the Definition of a Stored Procedure Back? 
Can You Pass Expressions to Stored Procedure Parameters? 
Why I am getting "The Microsoft .Net Framework 2.0 in not installed" message? 
System Requirements for SQL Server 2005 Express Edition? 
How To Use User Defined Functions in Expressions? 
How to grant a permission in MS SQL Server using "GRANT EXECUTE" statements? 
How to create a user to access a database in MS SQL Server using "CREATE USER" statements? 
How to connect SQL Server Management Studio Express to SQL Server 2005 Express? 
How do you know if SQL Server is running on your local system? 
What is the simplest way to create a new database in MS SQL Server? 
What is a database in MS SQL Server? 
How to delete database objects with "DROP" statements in MS SQL Server? 
How to delete a database in MS SQL Server? 
How to set the current database in MS SQL Server? 
What Are Exact Numeric Data Types in MS SQL Server? 
How To Use GO Command in "sqlcmd"? 
Why I am getting this error when dropping a database in MS SQL Server?
What Are Unicode Character String Data Types in MS SQL Server? 
What Are Character String Data Types in MS SQL Server? 
What Are Exact Numeric Data Types in MS SQL Server? 
What Is Transact-SQL Language? 
How To Count Duplicated Values in a Column in MS SQL Server? 
What Are the Differences between CHAR and NCHAR in MS SQL Server? 
What Are the Differences between CHAR and VARCHAR in MS SQL Server? 
What Is a Constant or Literal in MS SQL Server? 
Does Index Speed Up SELECT Statements? 
How To Use "BEGIN ... END" Statement Structures in MS SQL Server? 
How To Convert Numeric Values to Integers in MS SQL Server? 
How To Convert Character Strings into Numeric Values? 
What Is a Collation in MS SQL Server? 
How to download Microsoft SQL Server 2005 Express Edition? 
How To List All Schemas in a Database?
How To Transfer an Existing Table from One Schema to Another Schema in MS SQL Server?
Who Is the Owner of a Schema in MS SQL Server? 
How To Test a DML Trigger in MS SQL Server? 
How To Modify Existing Triggers using "ALTER TRIGGER"? 
How To See the Event List of an Existing Trigger using sys.trigger_events?
What is Microsoft SQL Server? 
How To Declare a Cursor with "DECLARE ... CURSOR" in MS SQL Server? 
How To Create a New Login Name in MS SQL Server? 
What Happens If NULL Values Are Involved in String Operations? 
How To Declare and Use Cursor Variables? 
How To Transfer Data from a Cursor to Variables with a "FETCH" Statement? 
How To Write a Query with a Full Outer Join in MS SQL Server? 
How To Insert a New Row into a Table with "INSERT INTO" Statements in MS SQL Server? 
How to rename an existing column with SQL Server Management Studio?