what’s the difference between Covering Indexes and Clustered
Indexes ?
how to use clustered index small ?
137
if a parameter is not send to a stored procedure what type
of identifier is to be used in Stp and if that parameter is
not feed to the a query inside the Stp how to validate with
out useing IF condition
How do you Implement SSIS Packages in your Project?
64
What will you do If the low Performance occurs?
33
how can you attach more than 20 ldf files in sql server
100
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
...
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?
104
If a stored procedure is taking a table data type, how it looks?
289
hi,
how to link a text file and a .rpt file in my tables of sql
server and to retrieve those records for further use. reply
me as soon as possible.