Isn't it true that if most of the indexes of a table in the where clause the dataset will pull up faster? Or is it that the dataset has to...

Here is what I have done.

CREATE   PROC usp_Insert

         @param 1 varchar(100), @param2 int, @param3 tinyint

AS

SET NOCOUNT ON

DECLARE @errStatus VARCHAR(100)

SET @errStatus = ''

BEGIN TRANSACTION ABC

 INSERT tblMaster

 IF @@ERROR <> 0

  BEGIN

   SET...

My Bad,

All the Rollback and Save Transaction are in IF ELSE statements. I had a SET NOCOUNT ON which was causing a problem, something like

NO COUNT ON

BEGIN TRAN ABC

INSERT INTO...

This is what i use

BACKUP LOG dbname TO DISK = 'C:\Bakup.log'     -- To Backup the Log file

BACKUP LOG dbname WITH TRUNCATE_ONLY       -- To Truncate the Log File

DBCC SHRINKFILE (file_name, reqd_file_size)       -- To shrink...

We are using templates with SQLXML, but we have disabled caching of templates. How does it affect in terms of the performance? We have over 700 templates that we use for...

Any takers for this one?

Thanks

I am trying to figure out whether dbreindex or indexdefrag is required for my database. I took one table as an example. I first executed dbcc showcontig and it gave...

What I mean by "I have users connecting from all over the country"? Ours is an OLTP system, with users logging in to the Application. The configuration is Clustered...

I don't know if the Transaction Log has ever been backed up before.

Can one tell me how to check the free space in the Transaction Log file?

What I did...

Here is the query...

SELECT a.no as no, a.date as date, a.key as key, a.memo as memo, b.name as name

FROM Cases_Table a INNER JOIN Dates_Table b on a.key = b.key

WHERE b.Name LIKE '%TICKLER%'...

The data is migrating from FoxPro --> SQL Server. We are using DTS for all data migrations. Using DTS for moving the data to a delimited file also truncates the...