Viewing 15 posts - 19,561 through 19,575 (of 22,202 total)
The bookmark lookup on TRNDTL_BTS08 is chewing up 90% of the cost of the query. The actual update changes a single row (according to this execution plan) but it has...
September 15, 2008 at 12:11 pm
PeterG (9/15/2008)
The table i am retrieving from (trndtl_bts08) has 150mil rows.
i know how to display...
September 15, 2008 at 11:13 am
Matt Miller (9/15/2008)
September 15, 2008 at 10:43 am
Jeff Moden (9/15/2008)
September 15, 2008 at 10:40 am
Have you looked at the execution plans to verify that the indexes were used at all?
For the clustered index, be sure that the column (or columns) that you put...
September 15, 2008 at 10:33 am
Jeff Moden (9/15/2008)
September 15, 2008 at 10:26 am
Different situations can cause either one to operate in a more optimal fashion.
Take the advice offered above. Do as proper a normalized design as you can to start. Then worry...
September 15, 2008 at 8:27 am
msreddyn (9/15/2008)
Thanks Samrath ,thats what exactly i am looking for
Thank you very much
True, but use it the way Peso posted it.
September 15, 2008 at 8:24 am
jay holovacs (9/15/2008)
I spent a number of years doing C++ (and loved it). TSQL and C# are very different tools and they solve very...
September 15, 2008 at 7:46 am
One thing I'm aware of in our organization, and I think it's universal. Object oriented developers loathe TSQL. I've watched blood pressures visibly rise in meetings when the discussion comes...
September 15, 2008 at 6:53 am
With only a little modification, you could use the code in this article:
http://www.sqlservercentral.com/articles/T-SQL/61461/%5B/url%5D
September 15, 2008 at 6:29 am
Performance, assuming a proper data design, good indexes, well written queries, etc., is not an issue. Supporting hundreds of users running queries is supporting hundreds of users running queries. It...
September 15, 2008 at 6:22 am
dmoldovan (9/12/2008)
However even if the applications share a SQL 2005 database you can still obtain some separation by placing the tables that are not common in different schemas.
True.
The problems...
September 12, 2008 at 12:37 pm
Greg Charles (9/12/2008)
Grant,Out of curiosity, what problems have you had with cross-database ownership chaining?
Thanks
As long as those two databases live forever side-by-side... None.
As soon as you put them on...
September 12, 2008 at 11:12 am
If the applications are not sharing substantial portions of data, different databases. Further, when you put them on different databases, don't allow cross-database queries. This is PAINFUL experience speaking.
September 12, 2008 at 9:15 am
Viewing 15 posts - 19,561 through 19,575 (of 22,202 total)