Viewing 15 posts - 16 through 30 (of 42 total)
November 4, 2010 at 10:56 am
jyurich (11/3/2010)
November 4, 2010 at 8:08 am
Jeff Moden (11/1/2010)
Hi Brian... I know who David Ziffer is... he wrote the article. I've probably missed it in one of your posts on this thread but who are...
November 2, 2010 at 10:40 am
RobertYoung (11/1/2010)
wbrianwhite (11/1/2010)
RobertYoung (10/31/2010)
wbrianwhite (10/30/2010)
All of the other techniques mentioned can built into a generator
I have a hard time believing this. How would a code generator know enough about...
November 1, 2010 at 7:34 pm
Jeff Moden (11/1/2010)Heh... there're a couple of dozen people on this site alone who are capable of pulling off huge multi-row inserts from a GUI via a stored procedure. ...
November 1, 2010 at 7:31 pm
RobertYoung (10/31/2010)
wbrianwhite (10/30/2010)
All of the other techniques mentioned can built into a generator
I have a hard time believing this. How would a code generator know enough about your application...
November 1, 2010 at 11:29 am
All of the other techniques mentioned can built into a generator
I have a hard time believing this. How would a code generator know enough about your application structure, data...
October 30, 2010 at 7:16 pm
Jeff Moden (10/30/2010)
I have a question based on the following snippet from the article...
First, I whole-heartedly agree with the principle of storing the same AuditDate when adding a "group"...
October 30, 2010 at 7:04 pm
David Ziffer (10/29/2010)
RobertYoung (10/29/2010)
October 30, 2010 at 8:41 am
And do you have terabyte+ data because someone never bothered with defining normalized data? Are you doing text processing? There is no de-normalize for performance. It doesn't...
October 30, 2010 at 8:39 am
RobertYoung (10/29/2010)
ron.buchanan.us (10/29/2010)
careusa2003 (10/29/2010)
I would not touch this design with a 10-foot pole.
If you are going to insult a design of which you know little about, at least elaborate. I...
October 29, 2010 at 11:12 am
As mundane as this might seem, these three routines provide some dazzling capabilities:
Not really. A history trigger is a far better choice. The stored proc can only ensure...
October 27, 2010 at 11:13 am
http://blogs.msdn.com/b/sqlazure/archive/2010/07/27/10043069.aspx
Just a note, non-clustered indexes (what you make when you do a covered index) reduce the performance of your writes. This is because on insertion or updates, the...
July 31, 2010 at 6:44 pm
It's amazing how often you don't need to worry about re-writing SQL when all that's needed is a new index, or updated statistics. If either of these two meet your...
July 30, 2010 at 11:10 am
Make sure your where clause is SARG-able or indexes won't help:
http://weblogs.sqlteam.com/dang/archive/2009/03/07/Low-Hanging-Fruit-of-Sargable-Expressions.aspx
July 29, 2010 at 3:40 pm
Viewing 15 posts - 16 through 30 (of 42 total)