SQL Server Interview Questions
Questions Answers Views Company eMail

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 4782

Without Using Cursors , How to Select the Selected row??

Wipro, CarrizalSoft Technologies,

3 5853

How many index can be created for single table

Verizon, CarrizalSoft Technologies,

4 12780

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


what exactly sql injuction.how to overcome.....



Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 2606

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

CarrizalSoft Technologies,

1 4902

How cand Optimize SQL Server Stored Procedures

1 2867

How many types of system privileges are there, Can we add or delete privileges?

2 4751

What is Online Index Rebuild Operation?

1 1805

What are the limitation of the Online Index Rebuild Operation?

1 1758

What Are Three Rules to UseĀ UNION IN SQL SERVER

1 4456

How to create Clustered Primary Key to table?

2 2568

Write a SQL Query to find first Week Day of month?

1 7277

How to find 6th highest salary from Employee table ?

9 14931

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.


what is the sql equivaent of the dataset relation object ?


1 01 101 01010


If the job running very slow what is the action you do


How you trouble shoot when any job fails


New concepts of sql server 2005 use in your project.


last function used in MS Access to convert sql what function will use in sql


how can you attach more than 20 ldf files in sql server


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?


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 to trouble shoot if unable to connect SQL Server


whats new about truncate in sql server 2008?


how to use DTS package in 2000,2005,2008 in sql server


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


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 ...