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 4841

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

Wipro, CarrizalSoft Technologies,

3 5920

How many index can be created for single table

Verizon, CarrizalSoft Technologies,

4 13174




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

827

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

CTS, IBM,

1262

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

2 2648

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

CarrizalSoft Technologies,

1 4931

How cand Optimize SQL Server Stored Procedures

1 2913




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

2 4823

What is Online Index Rebuild Operation?

1 1848

What are the limitation of the Online Index Rebuild Operation?

1 1796

What Are Three Rules to Use UNION IN SQL SERVER

1 4508

How to create Clustered Primary Key to table?

2 2616

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

1 7395

How to find 6th highest salary from Employee table ?

9 15365


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Why we need to use secondry database file? though, we can do same work using primary database file also.

4135


If we delete pack Spec what will be the status of pack Body ?

130


tell me the disaster recovery plan

1237


How much memory that we are using in Logshipping Concept?

660


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?

908






If a stored procedure is taking a table data type, how it looks?

4560


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

812


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

998


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1046


which backup strategy you are following at ur company

938


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1096


Scalability, Availability, Integration with internet, etc.)?

1588


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

611


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.

728


what is isolation level at dead lock?

968