I urge you to read BOL or Gails article.

This is a question that returns very frequent in the forum(s).

As always I'll provide the script from MS. Don't just run it,...

partitioning ?

- Think parallel IO

- limited scan (partition scan) if needed

- alligned indexes (i.e....

Indeed, but that also goes for a "regular" course.

How many times did one...

One of the problems with non-normalized solutions is you always have to figure out how to use it ...

So first normalize, then use, time and again ...

This solution uses Jeff...

Although I cannot answer your trace flag question, when installing / upgrading to sql2005, keep in mind to apply SP2 + the latest cumulative hotfix. (for the moment we apply...

K. Brian Kelley (8/13/2008)

---

Larry Johnson (8/13/2008)

---

Where's the ROI?

I can think of a lot better ways to spend $5000 than on a week of partying and networking in Seattle -- oh,...

also check...

http://www.sqlservercentral.com/Forums/Topic464157-145-1.aspx#bm551935

The huge advantage of varchar(max) compared to Text is you no longer need to use the special functions to manipulate text-columns, you can use them as variables, parameters, ...

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