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 4910

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

Wipro, CarrizalSoft Technologies,

3 6003

How many index can be created for single table

Verizon, CarrizalSoft Technologies,

4 13577




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

864

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

CTS, IBM,

1303

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

2 2701

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

CarrizalSoft Technologies,

1 4978

How cand Optimize SQL Server Stored Procedures

1 2983




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

2 4935

What is Online Index Rebuild Operation?

1 1903

What are the limitation of the Online Index Rebuild Operation?

1 1848

What Are Three Rules to UseĀ UNION IN SQL SERVER

1 4563

How to create Clustered Primary Key to table?

2 2689

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

1 7574

How to find 6th highest salary from Employee table ?

10 15817


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1049


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

864


1 01 101 01010

726


how to overcome kernel isssues

459


SQL Server Architecture ?

1120






what are the critical issues you have resloved in your company

808


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

703


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2669


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

865


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.

1254


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

662


How you trouble shoot when any job fails

674


optimization techinques

1307


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

296


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.

1601