Viewing 15 posts - 44,566 through 44,580 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 11, 2008 at 4:48 am
2000 or 2005?
What happens if a date is missing?
Is it homework?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 11, 2008 at 1:10 am
Brandie Tarvin (9/10/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 11, 2008 at 1:02 am
Arthur.Lorenzini (9/10/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 1:42 pm
It's not directly possible. A database will always restore with the same number of files as it had when it was backed up.
Once you've restored you can move objects...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 1:36 pm
Perhaps something like this will work?
SELECT object_name(i.object_id) as TableName, name as IndexName, KeyCount FROM sys.indexes i inner join
(select COUNT(*) as KeyCount, object_id, index_id from sys.index_columns where is_included_column = 0 group...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 1:33 pm
Could you give us more info please? Maybe give a couple of the queries you want to combine, show what they return now and show what you want them to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 1:29 pm
Viewing 15 posts - 44,566 through 44,580 (of 49,552 total)