at every checkpoint

When you switch recovery modes out of simple modes, then you do need a fullbackup. You can switch between bulk and full without this. If it fails after your load,...

Everything is part of a transaction. That is how the server can recover in between any crashes or reboots and maintain integrity.

select

o.orderid

, o.orderno

, sum( ssamount)

from ordermaster o

inner join orderdetails od

on o.orderid = od.orderid

group by...

Data consistency is needed within a transaction, which is what the log provides. A backup is a copy of the db at a point in time.

So if you backed up...

Tried to give them feedback, but the time wasn't long enough!!!

What did you have in mind? It can be hard to list a bunch of items for any particular date when people are all over the world.

If the web page has nothing to do with the job, not sure what the relationship is. Does the web page do more than run an insert and then need...

What about these???!?!

http://en.wikipedia.org/wiki/Steve_Jones_(basketball)

http://sports.espn.go.com/golf/players/profile?playerId=232

http://www.power-zone.com/zone.htm

Or maybe back to Earth on a Thursday: http://www.dkranch.net/images/steve/khali_dad_c.jpg

SQLServerCentral.com is built on a fw things. The forums are InstantForums (http://www.instantasp.com/) and has some controls. Other parts are custom developed. We use Lyris for mailing and BannerManPro for ads.

I...

There are a couple articles on NULL here and you can get some strange behavior depending on ANSI NULLs setting. Sometimes it isn't equal to itself

1GB isn't big, especially with a 300GB db. Why are you worried?

Moving tempdb to another drive will help it's performance, but if the server is slow, you might need a...

Do you mean logs into the console of the server / workstation? Check the startup stuff and the logs to see what file isn't being found or a clue as...

What account is the web page using to run the job? What rights does it have?

Also, if the job is started, you should be able to right click and get...

Most SQL Server tools aren't free and some aren't that cheap, but they are very useful and since you tend to buy fewer copies (less DBAs v developers) it works...