What's an "ooak"?

The thing I find amazing is that someone who claims to be a “senior DBA” would just jump in and do something without having a clue about what they...

It is very easy to make broken glass from bottles, though, and a lot more fun.

If SYBASE is doing the job, there would be little reason to change.

The cost of re-factoring the application is likely to be very high, so unless there is a really...

A small problem with the function is that it depends on the language setting of the users session.  The change below will allow it to check if StartDate is Sunday and EndDate is...

My point being that if the situation is as he described, he shouldn't be doing anything more, and certainly not trying to apply any advice from posts on this forum, because...

If this wasn’t a troll, I can't see a possible constructive response, other than to say, “Stop, don’t do anything else!  Find someone who knows what they are doing to help...

I really can’t believe that the original post is anything but a troll, and not a very good one.

I doubt that anyone who was really that clueless could actually delete...

The impact of the size of the table is not just about space on the disk or how long the backup takes to run.

If you have to scan a table...

You need to look at different options to keep your database backups to a reasonable run time.

If your database is multiple files or filegroups, you can backup...

All the ones I have looked at seem to be the same, but I can't say I was ever looking for differences.  I just didn't notice anything breaking.

declare @f float
set @f =20070809100330.0

select convert(datetime,stuff(stuff(stuff(convert(bigint,@f),9,0,' '),12,0,':'),15,0,':'))

This script will show you the size of all tables in the database.

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

Maybe you just have a lot of empty space in the database. ...

I prefer to use INFORMATION_SCHEMA for this type of work because it is an industry standard schema, and less likely to change if Microsoft changes the structure of the system...

You problem sounds like a hardware bottleneck, like not enough bandwidth on your network connection, poor performing disk drives on your target or source server, or not enough memory or...