Viewing 15 posts - 31 through 45 (of 51 total)
GilaMonster (1/31/2012)
DBA Rafi (1/31/2012)
After the sales process, i am seeing some factors which does not change, but more SELECTs on them, likeScenario #2: Static / Hardly-changeable Information (Master tables)
If...
January 31, 2012 at 12:33 pm
Michael Valentine Jones (1/30/2012)
SQL Kiwi (1/30/2012)
...Code that has NOLOCK on every single table in every single query is an infallible indicator of poor coding, in my experience.
I mostly agree with...
January 31, 2012 at 1:22 am
Kindly,
1. I knew the problem of dirty read. So, if i am OK with the regards. I shall very well go for this. Correct?
Because, i...
January 30, 2012 at 8:24 am
Thanks All for your Great Help. I glad about it.
January 30, 2012 at 12:59 am
Mr. Rahul,
Hope you misunderstood Koen Verbeeck's phrase "Why So Serious" !!!?
But Note, this was...
January 28, 2012 at 5:51 am
The Plan I posted is from my QA database.
January 23, 2012 at 10:10 am
Sorry LutzM,
I dont have permission to PRODCUTION Env.
Also, i dont know how to paste here the execution plan.
I regret i couldnt give you people the enough info in a single...
January 22, 2012 at 10:18 am
Yes Evil Kraig F,
It has the WHERE clause, just I shortened it.
January 22, 2012 at 5:02 am
Reason for my question is that, this SP is listed under 'Memory/CPU intensive Queries' by our performance tool.
* Index : All Tables are having Clustered Index
* Covered...
January 21, 2012 at 8:58 am
It is used Just to abort other scripts,
No codes are returned.
December 13, 2011 at 9:56 am
Yes. I agree that this cannot be 100% achievable by SQL as this depends on the code from C# or other which is out of SQL scope.
December 28, 2010 at 11:29 pm
Thanks for your detailed answers.
As you said, If such warning is not available in SQL Server, then It's fine. No Issues. I should go with that.
But I don't agree that...
December 28, 2010 at 11:06 pm
Thanks for your detailed answers.
As you said, If such warning is not available in SQL Server, then It's fine. No Issues. I should go with that.
But I don't agree that...
December 28, 2010 at 10:42 pm
1. I agree FK is good and its importance.
2. I am aware that there would be child tables which may refer mine. but that would be in FUTURE. In my...
December 28, 2010 at 2:25 am
Viewing 15 posts - 31 through 45 (of 51 total)