which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help3 4782
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 advance804
Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation2 2606
SQL Server Performance Tuning for Stored Procedures & reducing debugging time?1 4902
How cand Optimize SQL Server Stored Procedures1 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 SERVER1 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
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 ...