Reputation
939
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
6 25
Impact
~33k people reached

Mar
24
comment Can I export a maintenance plan without using Integration Services?
You can create and run maintenance plans without installing the SSIS service. The question is about how to export the plan when the SSIS service is not available.
Mar
18
comment Problem with pattern matching on unicode characters
The answers to this similar question illustrate the perils of relying on the collation's sort order when doing range queries. dba.stackexchange.com/questions/34730/…
Jan
6
awarded  Popular Question
Oct
26
awarded  Popular Question
Oct
21
awarded  Notable Question
Sep
9
awarded  Popular Question
Sep
5
awarded  Notable Question
Aug
25
awarded  Popular Question
Aug
23
awarded  Yearling
Jul
2
awarded  Curious
Jun
19
comment Normalization of Time Series Data
How are you measuring efficiency? Repitition of values is not necessarily a bad thing. In fact, in a column-oriented database, it's normal. A good engine will store value patterns efficiently.
Mar
29
awarded  Notable Question
Feb
6
awarded  Popular Question
Feb
5
awarded  Popular Question
Jan
11
revised How can I enforce ensure uniqueness of an association with a time dimension?
Explain query. Rearrange for clarity.
Jan
11
comment How can I enforce ensure uniqueness of an association with a time dimension?
@DavidBullock It's a useful reference, but Alexander Kuznetsov's solution requires a different table design. Is it strictly necessary?
Jan
11
answered How can I enforce ensure uniqueness of an association with a time dimension?
Jan
8
comment UPDATE a column by COUNT of another table
The join is ANSI-style, but the UPDATE as a whole is MySQL syntax. @ypercube Is it true that the only ANSI-compliant way to update one table from another is to use subqueries in the SET clause? It's horribly verbose.
Jan
8
comment Is it better to start with a smaller INT types and grow as needed?
It can be a lot of work to modify an existing schema, especially if the columns are referenced. By the time you realize that you need a bigger column, you might not have time to complete the modification work before the IDs would saturate. You could move old data to an archive table, but it's a nightmare to reconcile. Be warned!
Jan
6
comment Same table for real persons and fictional one
Can you tell us about the tables with foreign keys? Please show us a schema diagram, some table definitions, or some sample data. How do your applications use the real names? How do they use the fictional names?