What are functions3 6410
how to get the automatic backup of the database in the sql server4 31675
What command do we use to rename a db?5 8410
Which command using Query Analyzer will give you the version of SQL server and operating system?3 12127
What is the STUFF function and how does it differ from the REPLACE function?2 17046
What is the purpose of UPDATE STATISTICS?2 9974
What is de-normalization and when do you do it?3 5456
Explain some DBCC commands?6 14010
What is the purpose of using COLLATE in a query?1 16216
what are the Prerequisites for Replication?
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?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How you trouble shoot when any job fails
whats the maximum size of view state??
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
what are the critical issues you have resloved in your company
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
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.
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
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.
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
application server is slow what may be the problem
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)