I have a website that allows customers to browse and place
orders for certain products.
I have 2 tables; Customers and Orders. The Customers table
holds the customer records and the Orders table
holds the orders placed by the customer. Both tables are
tied based on the field Cust_ID.
Example of the data is shown below:
Cust_ID Cust_Name Cust_ID Product Amount Order_Date
1001 John Tan 1001 P-5211 $120.00 2/13/2006
1002 Michael Wong 1001 K-1428 $88.90 1/11/2006
1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006
1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006
Write a single SQL statement that extracts all purchase
records with the following criteria:
1. Customer names starting with “M” only.
2. Orders placed within the current month only.
3. Amount does not exceed $100.00
The list must be sorted by order date with the latest order
showing on top.
I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer.
1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication?
i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on...
1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
what is the sql equivaent of the dataset relation object ?
38
Can XML be used to access data?
75
What is the difference between referencing and joining?
109
What is indexed views?
plz explain with example?
61
How To Find That One Week Change in My DataBase we Have Done
Like We Have A database Test I Change Table,Stored Procd.
Then I Find Which SP,Table We Have Edit/Change in Seven
Dayes
74
If a stored procedure is taking a table data type, how it looks?
What is an execution plan? When would you use it? How would
you view the execution plan?
110
whate is advantages of sql server 2000
74
What is log shipping? Can we do logshipping with SQL Server
7.0 - Logshipping is a new feature of SQL Server 2000. We
should have two SQL Server - Enterprise Editions. From
Enterprise Manager we can configure the logshipping. In
logshipping the transactional log file from one server is
automatically updated into the backup database on the other
server. If one server fails, the other server will have the
same db and we can use this as the DR (disaster recovery) plan.
86
1.what is the diff between nolock optimizer and read
uncommitted
isolation?
2.what is the diff between revoke and deny?
3.what is percieved down time?
4.whether password protection are required for backups?if
yes why?if no why?
5.what is fill factor?
6.what is cost analysis?
7.what is mean by piece meal restore?
8.what is 'rowguidcol'?
9.impersonate permission?
10.what is selectivity?
40
Explain what are db_options used for?
139
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
75
Write a Select Query to display title for each group of
records, which are collected with Compute Clause?
Like
titlefield
column-A column-B .....
.....
.....
Sum
...
titlefield
column-A column-B .....
.....
.....
Sum
...
my problem is tempdb
tempdb(dbname) 77752.95 MB(db size) 25345.03 MB
(unallocated size)
suppose i increased temp db size 10 gb . after increase the
temp db showing
87 gb (dbsize) 25346.03MB(unallocated
size)--unallocated size is showing same .please clarify.
68
You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?
To Refer this Site to Your Friends 
Site Map
