we cannot have any non-clustered index if we don't have a clustered index on a table....also a primary key is by default clustered indexed and by definition unique.....

well...from your discussion...

The point in question is that how many copies of data you want to keep...if it is one....you can store it in only one order physically.....now by definition a clustered...

Use SQLCMD for this....

In MS Management Stusio(SSMS), you will find SQLCMD Mode under the Query menu....

Use the following script -

:setvar defaultserver

:connect $(defaultserver)

USE [master]

GO

select serverproperty('productversion'),

serverproperty('productlevel'),

serverproperty('edition')

Just change the...

I have a straightforward method of truncating the log file to the minimum size. Please note that one of the forum members have suggested me not to use it, but...

an might I know why we shouldn't use it?

It is the straightforward and most easiest way to empty the log file. If not, can you suggest any other method which...

Run the following script -

EXEC sp_dboption 'DATABASE_NAME','trunc. log on chkpt.','true'

CHECKPOINT

Then shrink the log file upto the min size specified.

Your log file will shrink. Any other method will take huge time.

Solve your orphaned user problem using the following script -

SELECT UserName = name

FROM sysusers

WHERE issqluser = 1

AND sid is not null

AND sid <> 0x0

AND suser_sname(sid) is null

ORDER BY name

EXEC sp_change_users_login...

You can use the following script for a specific database -

SELECT *

FROM sys.database_principals

WHERE [type] IN ('U','S')

AND ISNULL(default_schema_name,'')<>'dbo'

Thanks a lot. The post was really helpful. 'll surely keep those points in mind.

First of all you need to understand few basic stuff -

1> Select statements don't update/insert into tables

2> A primary key is unique and cannot have repetitive values

3> There is a...

when you are fetching data for a specific date, it is always advisable to get the input parameter in varchar(10), i.e., in mm/dd/yyyy format, or atleast convert the input datetime...

I am extremely sorry for this. I had done a EXEC

They are working fine. It happens you know, when in tight situation, getting the basic stuff wrong.

Anyway, as...

DO you have proper indexes in place for the databases?

David,

are you sure that you have bulk-logged as your recovery model?

What is the size of your database, and the average size of the log backups?

How frequent and in magnitude are...

First of all, if you have multiple database file groups and time is more of concern than point of recovery, you can have separate backups for the filegroups scheduled at...