Viewing 15 posts - 39,961 through 39,975 (of 49,571 total)
J-F Bergeron (4/6/2009)
Now, they are asking me to insert that "Price calcullation" within a query that will be used in the products screen. So when they will query a vendor...
April 6, 2009 at 9:58 am
Please note that the fixing portion of this article is solely looking at indexes. Nothing whatsoever on badly-written queries. That's another article and one that Tony will likely be nagging...
April 6, 2009 at 9:36 am
Vijaya Kadiyala (4/6/2009)
Simple tip about WHERE Condition, If you have "n" tables in FROM Clause then you need to have minimum n-1 where conditions to avoid any cross joins.
Better suggestion,...
April 6, 2009 at 9:20 am
prvreddy (4/6/2009)
1) Assume i have a stored procedure. It is taking more time, then what are key steps we look into about that query. I mean how do we do...
April 6, 2009 at 9:20 am
Look up sp_executesql. It allows passing of parameters to and from dynamic SQL.
April 6, 2009 at 9:13 am
radek (4/6/2009)
BTW: Of course I know, if I have small table that it is not good to create index.. but i dont know that 20000 rows is too small 🙂
No,...
April 6, 2009 at 8:39 am
Krishna Potlakayala (4/6/2009)
In your script you should also include something like i think it is if the number of pages >2000 then you should consider rebuilding or defragging them.
1000, and...
April 6, 2009 at 8:14 am
Ramesh (4/6/2009)
Now, if I would have posted that question in SSC and I would be very un-happy:crazy: if I receive a response such as "No interview questions".
If you had asked...
April 6, 2009 at 7:51 am
waqarlaghari (4/6/2009)
In quries it uses both words "Left Outer Join" and "Outer Join". So i was confused.
In SQL Server it's not possible to have just OUTER JOIN specified. Doing...
April 6, 2009 at 7:24 am
Small indexes often don't rebuild properly. It's nothing to worry about, fragmentation isn't an issue on such small indexes.
April 6, 2009 at 7:08 am
How big's the index? How many pages?
April 6, 2009 at 6:38 am
2cams (4/6/2009)
*********UPDATE**********I restored the Distribution DB DANKIE TOG!!!!!
Dis 'n plesier.
April 6, 2009 at 6:08 am
Lowell (4/6/2009)
April 6, 2009 at 6:07 am
Dean Jones (4/6/2009)
With regards to [Using low transaction isolation levels]How can this be doen with Delete and Updates, i thought it was mainly reads.
Read uncommitted is only for selects (and...
April 6, 2009 at 6:02 am
Viewing 15 posts - 39,961 through 39,975 (of 49,571 total)