Don't post entire blog articles here. It can be a violation of copyright, especially since it's not attributed. Could you please edit and remove it.

There are a lot of other,...

christophe (1/10/2008)

---

SQL servers keeps telling me that ROW_NUMBER isn't a valid function.

When I make it rank=count(*) SQL server struggles with the OVER keyword. I work via a SQL server management...

1) Get most of the research needed for my Masters complete. I'd like to be at the point of strting the write up by the end of the year.

2) Get...

Did you read the blog I referred you to?

Specifically look at the "Inside the storage engine" series he's written. It's explained far better than I could, and with diagrams...

Hmmm, that too!

With the varchars, the total space used on disk is 2 + number of characters in the field.

so a varchar(200) that has in it 'abc' only takes 5 bytes to...

You'll have to write a trigger for each table.

Pleasure.

p.s. SSCrazy is a title, not...

Is this related to the original question? If so, then none. Stats aren't going to help when stuff is missing from a table (which was the original problem)

If not (and...

It's not a new thing in SQL 2005. From SQL 2000 BoL:

DROP DATABASE permissions default to the database owner, members of the sysadmin and dbcreator fixed server roles, and are...

Download Virtual PC from microsoft. It's free. You can then download the virtual drives that Grant linked to and you can have 2008 running in a virtual machine with no...

It think you're wanting something like this?

SELECT substring (TAG , 10,30) as 'ALARM NAME', VALUE as '1=ON',

CONVERT(CHAR(27),(TIME),109) as 'DATE & TIME'

FROM dbo.UNIT_1_EMPTY_TABLE

UNION ALL

SELECT substring (TAG , 10,30) as...

You could install management studio express on each of the machines. If you have a machine with IIs installed, you could use reporting services. That way the clients access the...

Do your select with an update lock and with rowlock. Add a TOP 1 to the select. Try adding an index on JobStatus, JobID if there isn't one already

Also...

Unless it was a log record that was corrupt, you should be able to roll all the logs forward, right up to the last. If you backed up the tail...