103 reputation
5
bio website
location
age
visits member for 2 years, 4 months
seen Nov 5 at 17:03

Jan
8
comment Tuning query to remove joins for reporting
Because the original query was very poorly formatted, and I simplified the query to what was really needed.
Jan
8
revised Tuning query to remove joins for reporting
Edited bottom query and fixed typos
Jan
8
comment Tuning query to remove joins for reporting
They are both left outer joins, that was my bad.
Jan
8
comment Tuning query to remove joins for reporting
haha sorry, jon, I was typing it while looking at a different inner join on another screen.
Jan
8
revised Tuning query to remove joins for reporting
edited body
Jan
8
asked Tuning query to remove joins for reporting
Oct
4
answered SQL Server DB restore fails
Oct
4
comment Visio 2010 and SQL 2012 - Reverse Enginnering
Here is another post with a similar question. Since SQL Server 2012 came out after Visio 2010 it is not supported, even though it uses the Native Client.
Oct
3
comment How to store formula method in the table
so are you going to have a list of a handful of formulas that can be chosen from? Like (a + b + c) for HDD, (a + b) for HDD, (a+b+c/200) for HDD etc, or did you want it highly editable like enter formula for HDD here: ?
Oct
3
comment How to store formula method in the table
Are you trying to say you want a table of formulas that you use eval() in php with? I would just perform a join with formula table then perform a eval. Are you looking for something similar to this post?
Oct
3
awarded  Editor
Oct
3
revised How to store formula method in the table
fixed formula
Oct
3
awarded  Teacher
Oct
3
answered How to store formula method in the table
Oct
2
awarded  Scholar
Oct
2
accepted Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?
Oct
2
comment Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?
Max, thanks for helping me so much!
Oct
2
asked Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?
Oct
1
awarded  Supporter
Oct
1
comment SQL Server Snapshot Replication and SRDF compatability
Sorry about the confusion I am using SRDF from EMC with SQL Server 2008 R2's snapshot replication featuere. We have 3 machines 1: the original server, 2: validation server, 3: DR server. I am wondering if the SQL Server snapshot agent would break anywhere when using SRDF.