CREATE a table from another table2 2698
Get Current System Date Time2 2513
what is the difference between delete,drop and truncate2 3174
New concepts of sql server 2005 use in your project.
what is statistics1 2072
explain query execution plan1 2958
How you trouble shoot when any job fails
what is the sql equivaent of the dataset relation object ?
If we delete pack Spec what will be the status of pack Body ?
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?
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?
how many no of arguments can be passed in procedures and functions
Does any body please help me what question's have asked for SSRS in the interview?
How to trouble shoot if unable to connect SQL Server
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
How we create SQL Server 2005 Reporting Services ? Give me Sample
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?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
How retrieve field names from the table in SQL through JAVA code?