Viewing 15 posts - 47,101 through 47,115 (of 49,552 total)
Scott Duncan (3/25/2008)
CREATE INDEX [IX_Application2] ON [dbo].[Application]([DocumentNumber]) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
Ignoring the query for now (will look at it after I've had some coffee)..
I would 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
March 26, 2008 at 12:37 am
Mh (3/25/2008)
No. If the database is growing it's because...
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
March 26, 2008 at 12:34 am
Paul Koanui (3/25/2008)
Thanks for the reply. I'm just trying to figure out how two different databases on seperate machines with similar hardware would be performing so differently
Are 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
March 26, 2008 at 12:07 am
DBCC IndexDefrag is deprecated in SQL 2005. Use ALTER INDEX... REORGANIZE instead.
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
March 26, 2008 at 12:06 am
blahknow (3/25/2008)
Hi Gail, OK I understand there are no arrays.I create a table and i want to split it into "sub lists" (or "sub tables")
Hmmm. Ok. Why do 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
March 25, 2008 at 11:58 pm
Randy Doub (3/25/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
March 25, 2008 at 7:16 am
Can't see anything offhand that would make the update fal. It's not as if you're updating a row that the cursor's based off.
I'm not sure a cursor's necessary 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
March 25, 2008 at 6:04 am
Jeff Moden (3/25/2008)
Proof is always good... gotta love BOL. 😉
Habit from academic writing. Cite it or prove 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
March 25, 2008 at 5:50 am
karthikeyan (3/25/2008)
------------------------------------------Can you tell me why ?
Because it's an alternative to the while loop as you're written it. I'm not saying it will be better or worse in terms of...
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
March 25, 2008 at 5:48 am
Could you post the code please?
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
March 25, 2008 at 5:32 am
If you want to run a count(*) on all your tables, that's pretty much the way to do it. You could use a cursor instead of a while loop, or...
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
March 25, 2008 at 5:27 am
No arrays. Some people use XML, but that can get messy.
If you go into a bit more detail on what you're doing, maybe we can suggest an alternative.
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
March 25, 2008 at 4:46 am
Buxton69 (3/25/2008)
Marios Philippopoulos (3/20/2008)
I googled "trace flag 1118" and this was at the top of the list:PRB: Concurrency enhancements for the tempdb database
support.microsoft.com/kb/328551
But none relating to the proportional-fill process.
From what...
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
March 25, 2008 at 4:39 am
Koji Matsumura (3/25/2008)
SELECT roll, MAX(sname) FROM Table ORDER BY roll
SELECT roll, MAX(sname)
FROM Table
GROUP BY roll
ORDER BY roll
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
March 25, 2008 at 3:35 am
Probably very easy, but I do need a bit more info.
For Roll 1 you have sNames of 'aa', 'bb' and 'cc' Why is 'aa' the one you want returning, not...
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
March 25, 2008 at 1:54 am
Viewing 15 posts - 47,101 through 47,115 (of 49,552 total)