The 2 TB limit applies only to SQL Server 2008 R2 Enterprise Edition.

For SQL Server 2008 Enterprise Edition, the limit is Operating system maximum.

I think the big mistake that beginners make with triggers is using them at all. They see them as a sort of event driven solution, and don't really understand...

We have been using centralized servers for DTS and SSIS for several years for packages that mainly produce scheduled customer reporting deliverables like spreadsheets.

A big advantage is that it allows...

The script on this link shows how to generate a restore command using output of the restore HeaderOnly and restore FilelistOnly commands. Using this as a base, you can...

Transaction log backups should be scheduled to run much more often than once per day.

We usually run them every 15 minutes, 24x7. If the database has very high activity,...

You could expand with more on database design:

Failure to normalize

No primary keys or unique constraints

Inappropriate data types

Failing to define columns as not null

No foreign keys or DRI

No check constraints

Many...

It is best to do the selection on a date range, and not use a selection where your column is in a function call. If your column is used...

No need for that. Just do the INSERT in one statement so no one can get in between.

declare @MyTable (Run_id int not null )

INSERT INTO dbo.Jobs

( Run_id )

OUTPUT

INSERTED.Run_id

INTO

@MyTable

SELECT...

Convert it to total seconds first, and then you can compute the average seconds.

select

TotalSeconds =((Hours*3600)+(Minutes*60)+Seconds),

*

from

(

select

Hours= duration/10000,

Minutes = (duration/100)%100,

Seconds = duration%100,

*

from

( -- Test Data

select duration = 43856

) a

) aa

Results:

TotalSeconds Hours...

Serge, you should port your question on a new thread, instead of hijacking an old unrelated thread.

The most important thing with databases that size is to not give the job to inexperienced database designers and developers. No amount of hardware resources will make up for...

You cannot restore a backup of a SQL Server 2008 R2 database to a SQL Server 2008 server.

You can just add them together. Example:

select

a.[Date]+a.[Time] as DatePlusTime,

a.*

from

(

select-- Test Data

[Date] = convert(datetime,'2010-09-29 11:53:00') ,

[Time] = convert(datetime,'01:00:00')

) a

Results:

DatePlusTime ...

Why do you want to replace this? Is it causing some performance problem?

WHERE X_Column IN (SELECT parameter FROM fn_getParmTable(@input_parameter))

Trying to turn the the delimited parameter list into dynamic SQL...

You can see the fillfactor with this query. If it is 0 or 100, that means to completely fill the pages.

You can try reducing the fill factor by 10...