Indeed, the days of using dbo-schema for user objects are over. 😎

I advise to...

Rowsize > 8060 bytes ?

-table size is still limited by fixed-length types, as well as internal headers and row pointers.

-You cannot create a table with a row size of...

Glad that's been solved.

another little remark:

(from BOL sql2000)

The DUMP statement is included in SQL Server version 2000 for backward compatibility. It is recommended that the BACKUP statement be used instead...

Ross McMicken (8/12/2008)

---

Do you give sysadmin rights to a DBA's regular LAN ID? We only grant admin rights to special ID's that aren't used for anything else. That prevents a...

david.gerrard (8/12/2008)

---

I'd try not to give a website account any rights over the underlying data at all, and only Execute rights over stored procs to access the data.

Am I doing...

I'm quit with you Andy. :smooooth:

With one exception ... The DWH bulk loaders ;). They are being granted "bulkadmin".

We also implement our own reader/app (writer/exec-on-schema) / ReleaseManager db-groups and only...

sql (8/7/2008)

---

I've setup database mirroring with three servers:

A: Principal (Site A)

B: Mirror (Site B)

C: Witness (Site A)

Witness Server was placed in Site A, because at night time the link between...

First thing MS will ask you is :

- What SP level are you on ? (sp4 is the current)

- did you apply any hotfixes ?

If you are not on...

- run a trace to see what's going on.

(you can schedule a...

- 10% of 2.6Gb +-260Mb so that explains the file growth

- of that 260Mb (available after auto growth) you have already consumed (260-139) 121Mb.

No problem.

here's a nice overview ...

http://www.sqlservercentral.com/articles/63472/

http://www.codeproject.com/KB/database/SQP_performance.aspx

http://www.mssqltips.com/tip.asp?tip=1556

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspx

Written by yours truly :w00t:

I guess I lost track of this forum thread I'd launched myself.

Thanks for adding the link.

hth

This is not a challenge.

The point always is to find a thingy that works, alligned with what's reasonable, and...

Yuckon (7/25/2008)

---

Thanks for your suggestion,

DB Mirroring is not an option as I dont want the overhead on Server A - the load must be totally offline.

The reason I want to...