Jim has some good advice here. The main problem is trying to track the web user. If you move to requiring the person accessing the web site to log in,...

Do this:

set @sql = create login ' + @ip_newuser + ' with password = ''password'' ' ;

select @sql;

Take the output and look at it. Then try to run it manually...

If you have...

It depends on the developer. If...

And the organization of those objects. It looks like schema is another area where we've "reused" a word too many times.

The schema has always meant the design as well. What...

It's a fairly arbitrary concept and with conflicting information on the calculations, it's hard to understand what is correct. The way that it's given in the white paper, which is...

The schema affects query performance only in terms of how many joins you might need to perform queries, but any balancing out to reduce query time can increase resources to...

You have the logic there, just work through it.

First, check nickname. It it is null, then what? It looks like you are going a little too quickly with the logic....

Thiago is correct. I would do

Raid 1 - OS and backups

RAID 10 - tempdb, system dbs, data files

RAID 1 - log files

How many drives do you have?

Do not count on the index rebuild to fix this. As mentioned, an ORDER BY is required.

If anything was "working" before, it was coincidence, not causality. You could get the...

Please explain what the issue is and show all the code. You must tell us what you think should happen and what is not happening. From the code, there is...

stick tempdb and the systemdbs with the data files on R10. You likely won't get a huge benefit from separating them, and I'd combine them first.

Make sure you drop backups...

Filegroups are about manageability and recoverability (enterprise has partial database availability). The file stack drivers don't perform better with more files. You aren't getting any parallelism there. Most databases have...

Gentlemen,

You are welcome to debate this and it is interesting, but please keep it professional and agree to disagree about things that you cannot resolve. Please do not call each...

GilaMonster (4/27/2011)

---

I know one that likes to walk into the developers area "Why aren't you working?", "This had better be work" and similar statements. Any wonder she doesn't let me...