Forum Replies Created
Viewing 15 posts - 301 through 315 (of 49,552 total)
-
RE: Transaction logs
Do step 2 alone. That'll fix the excessive space. Once-off shrinks of the log aren't harmful providing you don't shrink to 0 and you have a sensible growth increment
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: checking for data exists in a multiple tables in single query
Please note: 9 year old thread
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: Why is sql ignoring my covered index?
That'll do the job nicely.
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?
I promise, from what I've seen of your roads, they're in good shape.
I remember a tour group in Scotland, the driver was cursing about the poor quality of 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: Why is sql ignoring my covered index?
Can you post the CREATE TABLE, CREATE INDEX statements and the actual plan 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 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?
jasona.work - Tuesday, February 27, 2018 1:02 PMGail 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?
This is part of the highway that's under renovation
South-bound on the upper level, north-bound on the lower.
For years now, whenever it rains there will be waterfalls across 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: Question about a composite key and autoincrement
jcelko212 32090 - Tuesday, February 27, 2018 10:58 AM
