Forum Replies Created
Viewing 15 posts - 23,686 through 23,700 (of 49,552 total)
-
RE: Adding PERSISTED Computed Column = INDEX Defragmentation?
If every page is full (not uncommon), adding a column could easily make every single page split because there won't be space on the full pages for the new column.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Adding PERSISTED Computed Column = INDEX Defragmentation?
Sure, it makes sense. You've widened the rows (by adding another column), SQL's going to have to split pages whenever the rows will no longer fit.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: How function will get execute internally in sql server?
Much the same way as a stored procedure or ad-hoc SQL batch.
What exactly are you looking for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: plz help me
Never heard the term. Where did you hear 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Where Do You Park?
bill.saunders1 (9/6/2011)
You find city living to be like water-boarding and I find driving to work to be like water-boarding. I just want people to be aware of the 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: New plan is created for every execution of stored procedure (query plan not reused)
praveen_vejandla (9/7/2011)
When profiler doesn't show signs of recompilations, naturally we expect that SQL Server might be reusing the existing plan but it is not the case here. A new plan...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Roy Ernest (9/6/2011)
Yay...!!! I beat the THREAD to the landmark. I hit 3000 posts before the thread hit 3000 pages. 🙂Congrats.
Easy to beat the thread's page count. Just change 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Talking about scores, I just noticed something...
Steve, you're next.... 😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL 2005 Max Memory Setting on Cluster
ALZDBA (9/6/2011)
MiguelSQL (9/5/2011)
...Min Server Memory is set to the same value as Max Server Memory, so I guess I'll have to adjust that value downwards to ensure that both instances...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Disaster Recovery Plan
If you tested the plan and managed to make all the SLAs involved, then it works. If you couldn't, it needs revising. That's what it comes down to in 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Database upgarde from SQL 2000 to SQL 2008
If you ignore the upgrade advisor warnings, there's a good chance the application will break on the newer version. You have to fix any errors it finds (or get 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Disaster Recovery Plan
Have you tested it? If not, that plan is not worth the paper it's printed on. If so, could you mean the downtime and data loss SLAs you have in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: New plan is created for every execution of stored procedure (query plan not reused)
praveen_vejandla (9/6/2011)
Now, profiler is not showing any recompilations for the stored procedure but for every execution of the stored procedure, a new plan is being used.How are you seeing 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Does ORDER BY clause matters if we have also used a TOP clause in query?
St3veMax (9/6/2011)
kirti.malukani (9/6/2011)
Yes, but I already have a clustered index on my salary column so do I need any external sorting as well?No; The clustered index physically sorts the data...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Query doing most IO and longest elapsed time
ananda.murugesan (9/5/2011)
Could you tell me, what is actual value output for most IO query and what is generally perfered value of IO in SQL SERVER 2008?Depends on what the query...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 23,686 through 23,700 (of 49,552 total)