how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?
code to create procedure for taking databse backup in sql
server or i have the query for it but what it's query
returns means i want to show on my jsp that the databse
backup has been taken on the basis of that return
value.does it returns 0 or 1.wat is the code for that
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.
168
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?
145
Tell about MOM Tool(Microsoft Operator Manager)?
39
What are the new features introduced in SQL Server 2000?
What changed between the previous version of SQL Server and
the current version?
Any one plz send me SQL Server Developer/DBA resume for 4
years experience
318
What is Fragmentation and Defragmentation? For 32GB
Table,How can we do the fragmentation?
27
How to restore performance issues and how to check?
28
How to Improve the performencs of SQL Server 2005 exclude
stored Procedure and Indexes?
141
A successfully created SSIS package in SQL Server 2005 runs
fine in MS BIDS and Integration Services. But gives error
when run through an SQL-Job. What are the possible reasons?
what’s the difference between Covering Indexes and Clustered
Indexes ?
how to use clustered index small ?
139
What is the difference between MVC and Teir Architecher?
Plz explain with Layyered Programming example...? Thanks
144
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
...
when u import an excel file into sql if suppose one column
has got a date field with system time attached to it what
data type u will use in sql to import it in a table?
Note: a condition is the excel file has no primary key
defined to a column...also u r importing bulk data into sql
159
Which command displays the SQL command in the SQL buffer,
and then executes it?
Site Map
