Jon of All Trades

less info
meta site favicon meta user | stack exchange network profile network profile
803 reputation
216
bio website
location Austin, TX
age 31
visits member for 2 years
seen 53 mins ago
stats profile views 51

23 Answers

newest activity votes
4
do user_scans and no user_seeks mean the index is useless?
mar 7 '12 at 18:43
3
Are two indexes needed?
jun 11 '12 at 15:06
3
Indexing of Data Warehouse tables?
sep 9 '11 at 19:12
2
Complex query with multiple normalized fields
mar 8 at 19:57
2
TSQL performance - JOIN on value BETWEEN min and max
may 11 '12 at 21:55
1
Can a surrogate key and a primary key be in the same table?
may 10 at 22:53
1
MySQL: Join one Row in a table with two Rows in other table
apr 17 at 21:38
1
MySQL: AVG of defined variable per month
jul 17 '12 at 19:07
1
SQL Server 2012 Data Warehousing Overall Flow
jul 24 at 17:41
1
ON DELETE cascade alternate
jul 20 '12 at 19:00
1
Parameter sniffing work arounds
jun 28 '12 at 20:25
1
Configuration Persistance Design
jun 12 '12 at 15:23
1
is id and phone number enough to uniquely identify a row in phone numbers
jun 11 '12 at 15:25
1
querying a table of events for reporting
may 30 '12 at 23:00
1
TSQL - Bringing Data Together from Different Sources …refactoring PK and FKs
may 11 '12 at 19:25
1
Is there a standard language/interface for programmatic ETL in SQL Server?
apr 19 '12 at 17:21
1
Cast NTEXT to INT for calculation and comparison
mar 30 '12 at 16:21
1
Merging Results while avoiding Key Constraint Error?
mar 14 '12 at 16:53
1
Design for storing data only applicable to a small subset of records
mar 7 '12 at 17:50
1
How can I track database dependencies?
jan 25 '12 at 18:38
1
Query becomes drastically slower when wrapped in a TVF
may 26 '11 at 23:24
0
Replicate DB2 table to SQL Server 2008
jul 3 '12 at 22:25
-1
Group by minute and two minute intervals
may 16 '12 at 16:33