Viewing 15 posts - 2,476 through 2,490 (of 5,843 total)
It's the Database!!! (8/5/2013)
August 5, 2013 at 11:46 am
Brandie Tarvin (8/5/2013)
TheSQLGuru (8/3/2013)
August 5, 2013 at 7:35 am
Very nice testing and investigative work Brandie! I thought there was more to this than initially (un)covered! I have saved this one off for future use.
August 3, 2013 at 2:13 pm
REALLY crammed with work this morning so didn't have time to set up a test or investigate, but is it possible to have 2+ tables with the same name belonging...
August 2, 2013 at 7:46 am
dkschill (8/1/2013)
August 1, 2013 at 9:32 am
Alan.B (7/31/2013)
TheSQLGuru (7/30/2013)
August 1, 2013 at 9:16 am
One more thing. If statistics staleness aren't in play here as Grant suggests, the other possibilities are:
a) data value skew, which could be helped by OPTION (RECOMPILE) on the...
July 31, 2013 at 10:07 am
Thanks Kevin, we would be looking forward for the performance tuning sometime in the future once we have all the database components / schema in place, right now I am...
July 31, 2013 at 10:03 am
Fortunately for you SQL 2012 has much better Windowing Function support. Look into the PERCENTILE_CONT function. I also HIGHLY recommend you purchase Itzik Ben-Gan's SQL Server 2012 High-Performance...
July 30, 2013 at 6:06 pm
mrinal.technology (7/30/2013)
In one of our database while executing a procedure serving an important business logic, which has 11 joins, then a filtering on a specific column, sorting using order by...
July 30, 2013 at 6:01 pm
No, not to my knowledge. See Books Online for various hints that can be used with FROM and JOIN, there are plenty of them (but BEWARE - if you...
July 29, 2013 at 9:02 am
1) Please don't post to 3 year old threads. Start new ones.
2) See here for lots of information about string splitting. Note that the best method is CLR,...
July 28, 2013 at 7:57 am
L' Eomot Inversé (7/24/2013)
TheSQLGuru (7/24/2013)
david.wright-948385 (7/16/2013)
Steve Jones
Please let us know what you think about the new design in the discussion for this article, with any comments or suggestions you have.
Are...
July 24, 2013 at 11:40 am
david.wright-948385 (7/16/2013)
Steve Jones
Please let us know what you think about the new design in the discussion for this article, with any comments or suggestions you have.
Are any of the suggestions...
July 24, 2013 at 8:01 am
Let me ask what you think partitioning will provide to "help you going forward". Most who start down this path start off with misguided ideas about what they expect...
July 23, 2013 at 8:09 pm
Viewing 15 posts - 2,476 through 2,490 (of 5,843 total)