Viewing 15 posts - 42,571 through 42,585 (of 49,552 total)
Doesn't look like a great config. How heavy's the SQL load going to be?
SQL doesn't work well with hyperthreading. SQL 2005 and 2008 are far better than 2000 was, but...
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
December 4, 2008 at 1:20 pm
Without seeing the query, the table definition and the indexes (and preferably the execution plan, as a .sqlplan file), it's hard to offer any useful advice.
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
December 4, 2008 at 1:16 pm
Raid 5 is not the best of ideas for transaction logs. Logs are write-heavy and raid 5 has the slowest write performance of any of the common raid levels.
If...
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
December 4, 2008 at 1:11 pm
Just the admin DB. Unless there's a need to keep the proc in master?
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
December 4, 2008 at 1:02 pm
You can't explicitly use the semi-joins. They're used by SQL when it processes an IN or an EXISTS. Both of those require that the contents be checked, but not joined,...
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
December 4, 2008 at 1:02 pm
rhubbard (12/4/2008)
Hello,This Meeting reservation would start on the 18th and end the 19th. The user reserved the room from 2008-02-18 17:00:00.000 until 2008-02-19 01:00:00.000.
So you want it to appear on...
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
December 4, 2008 at 12:58 pm
From the deadlock graph, you can see it occurred in the database with an id of 9 (that's why 9 was the first parameter to DBCC Page - DBCC PAGE(Database...
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
December 4, 2008 at 12:53 pm
Meeting start date today, or meeting end date today?
Would this one fall into 18th feb or 19th feb?
Liz Thomfohrde MS Offsite (TENTATIVE),Board Room,2008-02-18 17:00:00.000,2008-02-19 01:00:00.000
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
December 4, 2008 at 11:55 am
Create a login for this purpose and give it rights on the objects needed. You can give it a very long, complex password, since it's not intended to ever be...
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
December 4, 2008 at 11:37 am
Use EXECUTE AS on the DDL trigger so that the trigger executes under the context of a login that has access to the admin DB and all objects involved. That...
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
December 4, 2008 at 11:24 am
nazaninahmady_sh (12/4/2008)
would you please help me to write a T_SQL block for transfering data from one table in one data base to another table in another data...
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
December 4, 2008 at 11:11 am
Please don't create new threads for existing problems. There have been lots of answers to your questions on the other thread you started on this.
Please continue discussion on the following...
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
December 4, 2008 at 11:09 am
Take a look at line 123 of the procedure abc_Activity_Inquire. There's an insert statement there that's one half of the deadlock.
The other half is a piece of dynamic sQL somewhere...
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
December 4, 2008 at 10:46 am
declare @test VARCHAR(20)
SET @test = 'resumé'
select @test
There's a difference between extended ASCII and unicode.
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
December 4, 2008 at 10:08 am
Sanaullah (12/3/2008)
The SQL Server has been optimized for 8 concurrent query. This Limit has been exceededby 1 query and performance might be adversely affected.
You've got MSDE there. (free, restricted version...
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
December 4, 2008 at 9:56 am
Viewing 15 posts - 42,571 through 42,585 (of 49,552 total)