Viewing 15 posts - 43,696 through 43,710 (of 49,552 total)
Vishal Singh (10/17/2008)
What can be the best stratgey to deal with 10 Millns of user on one SQL database.
Well written, efficient queries and indexes that support those queries.
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
October 17, 2008 at 9:02 am
It's not a particularly comfortable time to be without a steady income (consulting), but things aren't as bad down here (South Africa) as in some other parts of the world....
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
October 17, 2008 at 8:18 am
Leo (10/16/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
October 16, 2008 at 3:46 pm
Do you know how I can go about deliberately corrupting a database. I'd like to test some different things, but I'm not sure how to go about it.
Sure....
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
October 16, 2008 at 3:42 pm
Can you post the trigger?
Is the insert fast when done on the server, but slow when done across a linked server?
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
October 16, 2008 at 2:07 pm
Yes, you can replace the two indexes. With the include columns, the order they appear doesn't matter.
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
October 16, 2008 at 1:02 pm
Yes. In fact I've just finished tearing my hear out over exactly that scenario (though I had 315 tables to do).
You can't do it with SQL 2000 though. It...
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
October 16, 2008 at 1:01 pm
Your strategy sounds good, though I might suggest running the tran logs more often. If the log drive fails, is the loss of 3 hours data acceptable?
I'd also suggest...
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
October 16, 2008 at 12:49 pm
As far as I'm aware, execution contexts are cached per user and per procedure, not for each statement in the procedure.
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
October 16, 2008 at 12:44 pm
Not really. The revised version (especially with more than 1 parameter) is likely to table scan all the time. That query has no single optimal plan
The usual recommendations (and often...
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
October 16, 2008 at 12:41 pm
Don't use locking hints, at least not as the first thing you try
Frequent blocking and deadlocks are usually caused by bad code, bad indexes or both. See if you can...
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
October 16, 2008 at 12:33 pm
Sure. This is the classic example
CREATE PROCEDURE AllOrSearch (
@SomeCode VARCHAR(30) = NULL
)
AS
IF @ID is null
SELECT * FROM SomeTable
ELSE
SELECT * FROM SomeTable WHERE SomeColumn = @SomeCode
If 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
October 16, 2008 at 12:12 pm
If it's an identity, why are the users allowed to enter a number? With identities, SQL allocates the numbers, not the client app. Also, with an identity, if a row...
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
October 16, 2008 at 12:05 pm
Have a look at uniqueidentifier with the newsequentialguid default. It may do what you want with no modifications at all.
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
October 16, 2008 at 11:55 am
Marcia Q (10/16/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
October 16, 2008 at 11:33 am
Viewing 15 posts - 43,696 through 43,710 (of 49,552 total)