HeavenCore

HeavenCore has asked 20 questions and find answers to 21 problems.

Stats

About

Software Engineer & Database Administrator.

Cohens Chemist Group (UK)

HeavenCore - Personal Site

Cohens Chemist - Work Site

SOreadytohelp

HeavenCore questions

Joining massive CTE tables (13,000,000 rows+) performance problems
Expand "From" & "To" date columns to 1 row per day within that range
Alternative to ROW_NUMBER() OVER (PARTITION BY x ORDER BY z)
Tricky where clause
Sage 200 - Counter table instead of Identity columns - strange behaviour
SQL Pivot with varying number of rows and compound key to form columns
imagecreatefrompng() + imagettftext() low quality text - how to anti alias
Regular Expression - Remove HTML comment spanning multiple line breaks
Identical code producing inconsistent image quality on different servers
Check Constraint – only allow one column to be true if another column is true

HeavenCore answers

Evaluate logical expressions in string column SQL
imagecreatefrompng() + imagettftext() low quality text - how to anti alias
How do I clean out all cookies?
Fancytree remove blue border when selected
Classic ASP Integrated Security in connection string
OLE DB Provider for ODBC Drivers Error "80004005'
How to check if gzip compression is enabled with PHP?
TSQL DateTime to DateKey Int
How can I ignore 'Arithmetic Overflow' related errors from within a data view?
How can I detect onclick() or similar for individual characters in a text?