I have a large xml file around 500 MB and I used to insert the data every day in one table, the issue is that I only want to use SQL Server to do this whole process. No VB and no asp envolve. Any idea? Thanks ...more >>

I am using the following query for fetching the data from the txt file..... but failed to do so.... select a.* from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\xml;','select * from Test.txt') as a Test.txt:- <ROOT> <Customer CustomerID="VINET" Con...more >>

What are the major difference b/w index hint and creating index on column Thanks ...more >>

if we create 1000 database users then is this create adverse effect on the master database? Thanks ...more >>

What are the maximum limitation of database user ? ...more >>

Any possibility? Right now I have a 600 MB space free and on my system I have a 6 GB backup file and I want to restore it on my own system.... I don't have any network where I have place this file and restore it from there and no DVD which support this 6 GB.... any possibility like when I res...more >>

I have created two jobs.. First Job... take the full backup daily at 12:00 AM Second Job...take the log backup every 1 hour till 11:PM The question is that if I include log shrinking command in the first job like First Job :- Step 1:- Declare @SQLStatement VARCHAR(1000) SET @SQLSta...more >>

Can we have more than one column alias for a sinle column in the select list. Something like this SELECT field1 A,B FROM Table...more >>

Can any one give me some idea regarding the major difference between working in Clustering environment and Non Clustering environment with respect of SQL SERVER. Thanks ...more >>

I am trying to take the backup into another machine which is on the network but failed to do so.... Like backup database Health to disk = '\\nSys0120\Backup\Health\bkHealth05172005' is the above command is okie ? Thanks ...more >>

I used "set statistics profile on" but I wanna know what are the most important columns to be considered like "Warnings", what others? Thanks ...more >>

I want to remove all the procedures from the cache... I used DBCC FREEPROCCACHE but doesn't effect. Any idea? Thanks in advance. ...more >>

I have find out one long running query through SQL Profiler and I copy that stored procedure and run in to query analyzer with the following settings. set statistics profile on set statistics io on set statistics time on In the output of warning column I found Null with all of them but wi...more >>

I just want to confirm from you that is this is the good practise if I can take full backup which size is 4 GB and log backup into another system instead of same system.... right now what I am thinking is the size of the backup is too larget so the network would be too jam if the full backup wou...more >>

Error while taking the backup..... I used the following command backup database test to disk = 'e:\bktest05172005' "e:" is basically a map drive. Error : --------------------------- Windows - Delayed Write Failed --------------------------- Windows was unable to save all the data for...more >>

Hi Here is the situation. Many clients simulteneously update the same table, but *never* the same rows. Each client has its *own* subset of rows. So there is theoretically no concurrency problem. Yet we are having locking issues. We use ROWLOCK hint but it looks like it does not do anyth...more >>

What would be the best practise to update the statistics like after how many DML transaction. Thanks ...more >>