385 reputation
414
bio website smelser.net/Blog
location Ireland
age
visits member for 2 years, 11 months
seen 4 hours ago

Yet another person contributing to the World Wide Parking Lot... I am a software engineer, blogger, and all around Star Wars nerd.


17h
comment How to join fixed row table against mapping table and reveal unmapped records
Tried to apply this but I am still not seeing rows that reflect the absence of a match through the junction table. The Cross Join feels right but as I said I am still missing the unmapped records.
1d
comment How to join fixed row table against mapping table and reveal unmapped records
@AaronBertrand Yes, I do...
1d
asked How to join fixed row table against mapping table and reveal unmapped records
Nov
24
awarded  Notable Question
Sep
22
awarded  Popular Question
Aug
6
awarded  Notable Question
Jul
2
awarded  Curious
Jun
17
comment SQL Server Reporting Services (MSSQLSERVER) Process using high memory
I generally just capture via system performance monitor
Jun
15
comment SQL Server Reporting Services (MSSQLSERVER) Process using high memory
I have now although I am concerned there is a dependency I am unaware of. It has been running benignly for a while and I’m concerned this is a symptom of a larger problem so I am trying to trace the root cause of the memory spike
Jun
15
asked DBCC TABLE CHECK seems to hang
Jun
15
asked SQL Server Reporting Services (MSSQLSERVER) Process using high memory
Jun
1
accepted deleting large volumes of rows from table efficiently in SQL Server
May
26
awarded  Editor
May
26
revised deleting large volumes of rows from table efficiently in SQL Server
Added index details
May
26
asked deleting large volumes of rows from table efficiently in SQL Server
Mar
29
awarded  Popular Question
Jan
23
awarded  Notable Question
Nov
7
awarded  Popular Question
Aug
1
awarded  Nice Question
May
22
awarded  Popular Question