what is the query and condition to delete datas in sql server.2 2526
what is diffence between replicaion and logshipping?1 2407
what is physical sort data and logical sort data in index?2 4560
how can do you the system monitoring?1 4798
what is the Enterprise manager(2000) and management studio (2005)?2 2543
How the data stores in a page?1 2492
what are the problems in logshipping?3 17822
How to tune a stored procedure?6 12060
what is index seek and index scan?2 9206
What is the difference between IN and EXISTS operators in SQL Server?9 56841
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?2 3288
can you any body tell me the difference between candidate key and primary key4 4435
how can u get last observation in an unknown dataset ?
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.
1 01 101 01010
New concepts of sql server 2005 use in your project.
System variable and temporary variables
What is best institute to Learn DotNET And SQL in chennai?
How to trouble shoot if unable to connect SQL Server
Tell about MOM Tool(Microsoft Operator Manager)?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How retrieve field names from the table in SQL through JAVA code?
what are the Prerequisites for Replication?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A