190 reputation
6
bio website
location United States
age 56
visits member for 1 year, 9 months
seen Jul 24 at 11:00

Design, develop and maintain C# WPF and ASP.NET business application with (typically large) MSSQL backends. Degree in engineering and got into computing via numerical methods.


Jul
17
comment Table with 4 million records - different size and performance in development and production
@ypercube But the dev database is 4.5 GB.
Jul
17
revised Table with 4 million records - different size and performance in development and production
deleted 2 characters in body
Jul
17
answered Table with 4 million records - different size and performance in development and production
Jun
20
comment how to solve slow running sub query TSQL
That posted example is not even valid syntax. You cannot know that example represents the performance issues the real query if it does not even run.
Dec
2
comment Huge slowdown to SQL Server query on adding wildcard (or top)
Did you look at the query plans? What do you mean fields are freetext? Freetext is a predicate used in the Transact-SQL WHERE clause.
Sep
18
awarded  Popular Question
Jul
11
accepted SQL Server not using available memory
Jul
11
comment SQL Server not using available memory
Thanks, that is one of the first things I should have checked. Will accept when it lets me.
Jul
11
revised SQL Server not using available memory
added 51 characters in body
Jul
11
asked SQL Server not using available memory
Mar
13
comment How to speed up SQL Server RIGHT JOIN on 100MM+ Records - use TVF?
CTE is just syntax. It get evaluated. Is that CTE_T, 500k of ~2MM evaluated multiple times? I think you need post the TSQL
Feb
14
awarded  Scholar
Feb
13
comment PK Fragmentation on INT IDENTITY column
Get what you are saying on maintenance plan. This is a 550 GB database so I need to maintain smart. My problem but you have helped me understand the problem. Thanks again.
Feb
13
accepted PK Fragmentation on INT IDENTITY column
Feb
13
comment PK Fragmentation on INT IDENTITY column
Query results added to question. I am going to go ahead and mark this as an answer as the question may get closed and I don't know if I can mark an answer on a closed question. Thanks
Feb
13
comment PK Fragmentation on INT IDENTITY column
Agree 10% was messed up. Will changed it to 50% and rebuild after a backup. Kind of a long story but when I was using @@Iden it was causing fragmentation that got fixed by scope_identity - really.
Feb
13
comment PK Fragmentation on INT IDENTITY column
Great tip on fill factor. What about pad index? I will post the table structure.
Feb
13
comment PK Fragmentation on INT IDENTITY column
SSMS - I reorganized and it went to 0.2%
Feb
13
comment PK Fragmentation on INT IDENTITY column
Int32 Inden 1, 1
Feb
13
asked PK Fragmentation on INT IDENTITY column