Viewing 15 posts - 44,986 through 45,000 (of 49,552 total)
SQL Noob (8/15/2008)
in most cases where tables and indexes have to share the same disk you have to denormalize depending on your environment to get performance.
I'm going to disagree...
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
August 15, 2008 at 1:59 pm
Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums.
No replies to this thread please. Direct replies to
http://www.sqlservercentral.com/Forums/Topic553744-92-1.aspx
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
August 15, 2008 at 1:46 pm
Alter trigger ... with append was deprecated in SQL 2000 and removed in SQL 2005.
What are you trying to do?
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
August 15, 2008 at 1:40 pm
KB (8/15/2008)
What kind of permissions do a user need to have to connect to a linked server?
Virtually none, which is, IMHO sometimes a problem.
What's wrong is that you haven't set...
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
August 15, 2008 at 1:31 pm
GSquared (8/15/2008)
I just installed a trial copy of 2008 today. Tested both Intellisense and debugging on 2008 and then...
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
August 15, 2008 at 1:18 pm
Those are the estimated execution plans you have.
Is there any chance of you running the query in management studio with the "Include actual execution plan" option on?
Dev could have different...
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
August 15, 2008 at 11:43 am
Task manager doesn't show AWE memory. I think there's a bit more to it as well.
I personally don't trust it for SQL memory. Other stuff's ok.
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
August 15, 2008 at 11:41 am
A few comments...
Replicated databases do not require full recovery mode. That's true of log shipping and database mirroring. Replication works fine in any recovery mode.
Don't shrink databases on 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
August 15, 2008 at 11:40 am
rbarryyoung (8/15/2008)
Can you just give us the before and after *.SQLPlan files?
Problem is those also have the query included inside them.
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
August 15, 2008 at 11:20 am
Better but you're still assuming that there will only be one row in the inserted tables, example the following line
SET @ProductID=(select ProductID from inserted)
There could be any number of rows...
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
August 15, 2008 at 11:18 am
MrBaseball34 (8/15/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
August 15, 2008 at 11:14 am
Select name, index_id from sys.indexes where object_name(object_id) = < Table name >
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
August 15, 2008 at 10:41 am
Task manager is not necessarily accurate for SQL Server memory, especially if you have AWE enabled.
Use Perfmon and look at process(sqlservr): working set or SQL Server buffer manager:Total server memory
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
August 15, 2008 at 10:31 am
ALTER INDEX ... REBUILD
or
ALTER INDEX ... REORGANIZE
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
August 15, 2008 at 10:30 am
Mostly, just the logical scan fragmentation %
Above 30%, rebuild the index. Between around 15 and 30, reorganise.
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
August 15, 2008 at 10:22 am
Viewing 15 posts - 44,986 through 45,000 (of 49,552 total)