For the third time, the maximum limit to concurrent connections in SQL Server 2005 is 32767.

The value that you see under the server properties - connections can be set by...

Merge replication != minimal overhead. In my experience, it's the type of replication that puts the most load onto the servers. It sounds like what you want is peer to...

Any chance of duplicate dates?

A covering index is an index that contains all the columns that a query references. An index may be covering for one query and not for another.

I just did. 32767 is the maximum possible simultaneous connections to a SQL Server instance. The...

Please post SQL 2000 questions in the SQL 2000 forums in the future. Posting in the 2005 forums means that people will give you 2005-specific solutions.

Are the dates always consecutive?...

Firstly, there is no quick fix for performance. If the DB and queries are badly designed, adding hardware won't help much, if at all.

Replication may help, but note that replication...

SQL doesn't have any quotas. The max number of concurrent connections possible to an instance is 32767, but you'll need one seriously powerful server (with tonnes of memory) to handle...

2000 or 2005?

What happens if a date is missing?

Is it homework?

Possibly related to general network activity. I know that every time someone else finished their exam, mine (and all others in progress in the room) promptly reset.

Perhaps this?

SELECT name, course, null as course1 FROM Table1

union all

SELECT name, null as course, course1 FROM Table2

Please post in the correct forum next time. The question of the day forum...

Can you post the procedures?

For a brief overview of parameter sniffing -

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/

Please don't cross post. It just wastes people's time and fragments replies

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic567472-24-1.aspx

What it looks like is that both processes had a shared lock (probably from a foreign key check earlier on) and then both wanted an exclusive. Neither can get the...

Brandie Tarvin (9/10/2008)

---

4 times the stupid thing terminated on me, twice during my review session. Always when I clicked the "next" button. Fortunately, it saved all my answers. Unfortunately, I...