Viewing 15 posts - 48,316 through 48,330 (of 49,552 total)
Makes sense.
Try moving the cluster to logdate (or if you do queries by date and time, to a logdate and logtime together). Is not ideal, but is better than...
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 25, 2007 at 5:19 am
Osama Kandil (10/25/2007)
3. In all your T-SQL queries, you must use:if Varcharcol1 like '%chocolate' or Varchacol2 like '%chocolate' or .. Varchacol10 like '%chocolate' then ...
With wildcards at the begnning 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
October 25, 2007 at 1:17 am
Full text does sound like the best option.
If you don't want to go full text, and your queries are always of the form
SELECT FROM ItemDetail WHERE ItemcodeDescription...
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 25, 2007 at 1:05 am
Cross post. Please continue discussions here
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 25, 2007 at 12:56 am
It appears you have a user in the db named sys. Sys is reserved in 2005, it's the system schema.
Try changing the user name to something else in SQL 2000,...
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 25, 2007 at 12:52 am
Did you shrink the data files, or just the log file? If the data files, you need to check the index fragmentation as the shrink probably shuffled the index...
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 25, 2007 at 12:48 am
Have you considered inplementing full-text indexing?
Could you possibly post the schema and the query so we can take a look?
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 25, 2007 at 12:32 am
Ok, there's a few issues at play here.
Your filter (LEN(desthost)>1) is forcing a table scan, as any function on a column prevents usage of indexes for that condition. (See this...
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 25, 2007 at 12:20 am
Offhand, I'm not sure you can upgrade that. The upgrade path from MCDBA SQL 2000 to ITP Admin is 2 exams (70-431, 70-447) while the non-upgrade route is three. (70-431,...
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 24, 2007 at 3:00 pm
My instinct says the second should run faster, but there's only one way to really find out. Try them both out on a test server (wrapped in begin transaction ......
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 24, 2007 at 2:50 pm
CJR (10/24/2007)
I have the stats from perfmon on this now but need to analyze, I see the avg disk queue length was 16.4 with a max of 116.
Wow. Is 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
October 24, 2007 at 7:49 am
Found em.
Back to the subject of shrink. Have you tried several smaller shrinks instead of one large? If you're trying to shrink the file...
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 24, 2007 at 6:50 am
Hmmm....
Are those disks in a RAID array, or are they single disks?
Be careful with write caches and SQL server. Not so much of an issue, since its a dev 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 24, 2007 at 6:39 am
Steve Jones - Editor (10/24/2007)
Conversely, lots of people think theory has no place in the game.It helps.
Agreed. I did, amoung other courses, compiler theory, 2 forms of assembler, low-level networking...
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 24, 2007 at 6:28 am
Could also be that there's a trigger, or that the foreign and unique constraint checks are taking the time on the insert. They shouldn't but...
That's the main reason I want...
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 24, 2007 at 6:26 am
Viewing 15 posts - 48,316 through 48,330 (of 49,552 total)