237 reputation
29
bio website ledgerscope.com
location Bingley, United Kingdom
age 28
visits member for 2 years, 4 months
seen yesterday
stats profile views 24

Software Developer at Ledgerscope


Apr
8
awarded  Nice Question
Feb
15
awarded  Notable Question
Dec
13
answered How can I profile SQL Azure?
Aug
28
awarded  Yearling
Aug
28
awarded  Teacher
Jun
1
revised What database technologies do big search engines use?
I know it's a small change, but title said "to" instead of "do"
Jun
1
suggested suggested edit on What database technologies do big search engines use?
Mar
16
answered Is it possible to check a date in SQL?
Dec
24
awarded  Commentator
Dec
24
comment Temporarily disable checking of constraints
I do indeed mean that the index wasn't used. I'll have a look at that link. Thanks
Dec
24
asked Temporarily disable checking of constraints
Dec
22
accepted Physical Address Schema
Dec
16
comment Physical Address Schema
What if (for example) I was looking at storing addresses against records in a user table, and addresses against records in a customer table
Dec
16
awarded  Editor
Dec
16
comment Physical Address Schema
Thanks @gbn, I've updated it now
Dec
16
revised Physical Address Schema
Clarified where foreign keys were going
Dec
16
asked Physical Address Schema
Oct
3
awarded  Popular Question
May
25
comment SQL Azure Fragmentation / Database Size
Unfortunately both sys.database_files and FILEPROPERTY don't exist in SQL Azure so I can't execute this query.
May
24
comment SQL Azure Fragmentation / Database Size
Thanks for your answer. Will the gaps get filled by data as time carries on? Eg If my database were to grown by another 200mb would some of the data end up occupying the 130mb that is unoccupied? If not are there any commands I can run to solve this (out of hours)