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...

Not this exactly, but Andy had some queries that would run fine for weeks and then all of a sudden start grabbing different query plans.

I suspect that you have some...

Don't use !=, it can cause issues. Use IS NULL or IS NOT NULL

You might need to burn the $249 and call PSS. I'd bet that the driver is flaking somehow. We got some strange results from DB2 with the Client Access driver...

You can run Profiler and watch for queries when the tempdb is growing. If this is a function of the data increasing (larger results in queries) then there's not much...

Need to find out why tempdb is growing so much. What is happening in your code that is causing tempdb to jump.

Used to play rugby myself in college. One torn shoulder later I just watch my 7 year old in flag football. Looking forward to him hitting people next year.

Living in...

Might have been "More?" a few years ago. After 3 kids, it's probably "one, two floor"

Havne't looked at the Maint Plans, but that's something to check out.