If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead?
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
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?
What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable)
10
What is the difference between referencing and joining?
198
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
Which is the best place or learning center for MS SQL?????In
Bangladesh?????
87
how to take backup bcp out for a column in table in sql
server?
175
Can anyone tell that the extra features are there in SQL
SERVER 2008 that are not available in previous versions .
62
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.
128
How we create SQL Server 2005 Reporting Services ? Give me
Sample
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
164
i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
104
1. Tell me your daily activities
2. If sql server installation fails at time
installation what will do
3. Where does the sql server installation log details
are stored
4. After the installation what will you do for memory
configuration
5. What is the difference between SQL max maximum
memory and AWE memory
6. How will you configure AWE memory
7. How will setup an email alert for the backup job
8. After the SQL installation what are the jobs will
you configure
9. What does –g mean in the sql startup parameter
10. What is the difference between Bulked log and Full
recovery model
11. What is the difference between mirroring and log
shipping
12. What are the steps to be followed before in-place
up gradation
13. After installing the patch the sql server does not
start and application team tells to rollback the
changes .In this scenario what will you do
hi,
the following are the outputs of sp_spaceused and
sp_tempdbspace
sp_spaceused
------------
database size unallocated size
tempdb 77752.95 MB 28026.99 MB
sp_tempdbspace
-------------
database size spaceused
tempdb 77752.945312 1.007812
the unused space in sp_spaceused is nearly 28 Gb and in
sp_tempdbspace is nearly 76 Gb
cany any one explain about this output and why its giving
different results.
166
One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d f f
g h
32
Which command executes the contents of a specified file?
How to restore performance issues and how to check?
26
If we shrink the Databse and Files, how much size is
decreased?
60
How to write the storeprocedure with in the store procedure?
and how can we write the store procedure with in a trigger
vice versa? plz post me the exact answer?
To Refer this Site to Your Friends 
Site Map
