Viewing 15 posts - 44,581 through 44,595 (of 49,571 total)
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...
September 11, 2008 at 6:20 am
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...
September 11, 2008 at 6:14 am
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.
September 11, 2008 at 5:17 am
poornima.s_pdi (9/11/2008)
Could u tell me totally how many connection possible in SqlServer?
I just did. 32767 is the maximum possible simultaneous connections to a SQL Server instance. The...
September 11, 2008 at 5:16 am
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?...
September 11, 2008 at 5:15 am
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...
September 11, 2008 at 4:57 am
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...
September 11, 2008 at 4:48 am
2000 or 2005?
What happens if a date is missing?
Is it homework?
September 11, 2008 at 4:45 am
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.
September 11, 2008 at 4:43 am
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...
September 11, 2008 at 1:55 am
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/
September 11, 2008 at 1:43 am
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
September 11, 2008 at 1:13 am
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...
September 11, 2008 at 1:10 am
Brandie Tarvin (9/10/2008)
September 11, 2008 at 1:02 am
Viewing 15 posts - 44,581 through 44,595 (of 49,571 total)