9,117 reputation
1635
bio website
location
age
visits member for 3 years, 9 months
seen 1 hour ago

2d
answered Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Oct
18
awarded  Taxonomist
Oct
17
answered What backup/restore strategy can I use for the following scenario
Oct
14
answered SQL Server combine Update and Delete
Oct
13
comment Is the runtime of checking for duplicate primary keys in SQL Server O(n)?
It is only "effectively O(1)" with respect to IO operations that result from the activity, not the actual index navigation algorithm, because with a table that sees regular use you are unlikely to see more than a page or two read from disk when comparing one value against the primary key. You shouldn't bank on the ideal case though. Considering just the algorithm and not storage structures, searching for a value a structure with a balanced index is an O(log N) operation.
Oct
8
answered Scrubbing sensitive data
Oct
8
comment SQL Server 2012: Full Text Catalog taking up all the disk space
@Saikat: You should edit the extra information into your question otherwise other people might see it but not respond because the don't see enough detail and they don't have time to ask for it and come back later. Extra detail that is present only in comments can get lost on the page to a passer-by.
Oct
3
comment varchar storage and comparisons in SQL Server 2008
The expense of generating the checksum/hash is in CPU time and even then it isn't very high, so should be insignificant compared to the general cost of writing new/updated rows. Doing it in the data layer means that the database can enforce it always getting updated rather than risking later code touching the table and someone forgetting that this needs to be done.
Oct
2
comment How to split one big table that has 100 million data to multiple tables?
You'll have to tell us more before we can even begin to answer that in a way that isn't open ended and therefore might be not all that useful. What is the total size of those rows, what is their structure (columns, indexes) and how would you like it split? (on specific discrete values from a particular column, or something more complex).
Oct
2
comment SQL Server: Clarity on which service user does what (backups, etc) RE accessing network shares
I assume he means stand alone to mean they are not part of any clustering by or replication arrangement.
Sep
30
awarded  Explainer
Sep
30
answered 1000 visitors per day have my web page and MySQL scratching at certain times and my.cnf
Sep
30
revised rebuild on clustered index, why does datasize shrink?
added 430 characters in body
Sep
30
comment rebuild on clustered index, why does datasize shrink?
@Shanky: That ALTER INDEX statement looks like it was generated by code (as it includes a bunch of options in their default setting) so I suspect that it was built from the existing options of the index. But you are right: if compression wasn't enabled on the clustered index before this was run then that would definitely explain most of the reduction in data footprint. (again: Daniel, could you confirm one way or the other?)
Sep
30
awarded  Nice Answer
Sep
29
revised rebuild on clustered index, why does datasize shrink?
Minor corrections
Sep
29
revised rebuild on clustered index, why does datasize shrink?
Added notes on fill-factor, reindex example, and updates on variable length rows
Sep
29
revised rebuild on clustered index, why does datasize shrink?
Added notes on fill-factor
Sep
29
revised rebuild on clustered index, why does datasize shrink?
added 400 characters in body
Sep
29
answered rebuild on clustered index, why does datasize shrink?