Viewing 15 posts - 28,081 through 28,095 (of 49,552 total)
The char(12) is part of the problem. All the values are placed into that as a single comma-delimited string (it's not an array). Hence you need to make that a...
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
January 28, 2011 at 9:54 am
vj2173 (1/28/2011)
From your diagram, am I to assume that the root page contain the indexed column and all of the values from the index column. From1 to 137?
No. Just...
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
January 28, 2011 at 9:50 am
I'm not sure I understand you. I suggest you read parts 2 and 3 where I have diagrams of the index structure.
The only level of the index that has 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
January 28, 2011 at 9:10 am
The maximum allowed number of concurrent connections is 32767. So no, 100 000 users will not all be able to connect at the same time.
That said, unless you have some...
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
January 28, 2011 at 8:57 am
Bear in mind that silly tricks (like adding a predicate that qualifies all rows) will not make queries run faster. Tuning queries by trying to force specific operators is also...
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
January 28, 2011 at 7:13 am
Restore from a backup from before the delete. If the DB is in full recovery and you have log backups you can restore to a new database and to just...
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
January 28, 2011 at 6:53 am
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
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
January 28, 2011 at 5:56 am
Abhijit More (1/28/2011)
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
January 28, 2011 at 5:54 am
I added some data (a couple hundred thousand rows) and compared the original and the challenge requirement.
INSERT INTO TableX (x_value1, x_value2, x_value3)
SELECT TOP (250000) GETDATE(), 'abc', a.object_id + b.column_id
FROM master.sys.columns...
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
January 28, 2011 at 4:30 am
Abhijit More (1/28/2011)
The challange is to convert the Index Seek to Clustered Index Seeks.
Why? The index seek should be more efficient.
btw, any form of exec plan investigation is meaningless...
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
January 28, 2011 at 4:21 am
Please post new questions in a new thread. Thank you.
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
January 28, 2011 at 2:37 am
sql_butterfly (1/28/2011)
As per my standards, the best execution plan should look like when you can see the 100% Index seek from a table (within a query).
I disagree. Only 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
January 28, 2011 at 2:24 am
Ramji29 (1/27/2011)
GilaMonster (1/27/2011)
p.s. Nolock?
Are you talking about the one table I missed nolock hint or sumthing else??
No, I'm wondering why you're using them at all. I assume since you're using...
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
January 27, 2011 at 4:01 pm
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
The problem is that if SQL creates a plan with a seek and on a second call the parameter is null the query would return incorrect results. The plan must...
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
January 27, 2011 at 3:43 pm
When I do interviews I always include one 'unanswerable' question. Just to see if the candidate will admit that he doesn't know or if he's going to make up some...
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
January 27, 2011 at 2:56 pm
Viewing 15 posts - 28,081 through 28,095 (of 49,552 total)