256 reputation
15
bio website
location
age
visits member for 2 years
seen Dec 28 '13 at 9:49

Jul
16
awarded  Yearling
Dec
19
answered Large scale, hard to model design advice needed
Aug
23
awarded  Scholar
Aug
22
comment What units are 'reads' and 'writes' in dm_exec_query_stats
Thanks Aaron, I had a suspicion it would be pages. I marked your answer as correct because of your references.
Aug
22
accepted What units are 'reads' and 'writes' in dm_exec_query_stats
Aug
22
awarded  Student
Aug
22
asked What units are 'reads' and 'writes' in dm_exec_query_stats
Aug
14
comment Make sure two columns are sorted in the same order
I don't think you can guarantee uniqueness with just CreateDateTime. Clocks can be reset forward and backwards. Events can happen so quickly they appear to happen at the same time. (I almost convinced myself I could make a datetime2 column the PK of my log table, but you really need to include an IDENTITY column to ensure uniqueness).
Aug
14
comment Make sure two columns are sorted in the same order
Also be careful your GETDATE() doesn't jump backwards or forwards in time (eg: because someone adjusts the server clock, or daylight saving).
Aug
8
awarded  Supporter
Aug
3
comment single select vs multiple selects using limit and offset
According to TechNet Read Committed Snapshot and Snapshot isolation levels are enabled by default in Azure; query sys.databases to confirm. Both those isolation levels allow selects to read data even if records are locked by another transaction (even Serializable ones). Your reader will see an older version of the data.
Aug
3
answered single select vs multiple selects using limit and offset
Jul
20
awarded  Editor
Jul
20
revised Optimising MySQL
Changed drop and recreate for db engine change to alter table
Jul
20
comment Optimising MySQL
@randymelder - I stand corrected!
Jul
19
comment Sql server 2008 filestream maximum number of rows
I've been toying around with filling NTFS folders with obscene numbers of files recently (random pet project of mine). Performance tanks in Explorer around 1M, but most file system operations are OK up until you exceed the file system cache. 20k files shouldn't pose a problem.
Jul
16
comment Poor performance after changing SQL Server 2008 R2 database
finagle verb - to improve the performance of a SQL query by tweaking an incorrectly chosen JOIN operator. Eg: "My query suddenly ran slow, so I finagled the merge join into a hash join"
Jul
16
awarded  Teacher
Jul
16
answered Optimising MySQL