185 reputation
6
bio website
location United States
age 55
visits member for 1 years, 6 months
seen Dec 6 '13 at 15:09

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.


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
Dec
18
awarded  Teacher
Dec
18
answered How to delete large amount of data from a sql table?
Dec
12
comment Why is my database stuck in the Restoring state?
Why is this tagged .NET?
Dec
8
awarded  Commentator