Hi All, Sorry to inform you that I need to get back to some hot projects for my company. I'll try to post the execution plan as soon as I have...
Hi guys,<br /><br />here are some results<br /><br />1)<br /><br />DBCC DROPCLEANBUFFERS<br /><br />DBCC FREEPROCCACHE<br /><br />select...
Hi guys, Ok to provide you data for your article. (I've to find some time to do it...) We've run another query which is important for us and which...
I am no the tester but I've told them to use your DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE in order to have real tests. get back soon...
Hi guys,<br /><br />I can see that this topic interests some sql'ers <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />I'm going...
Ok guys,<br /><br />Here are first results :<br /><br />with old structure :<br /><br />Q1 : SELECT * FROM Users WHERE idUser = 10<br />Q2 : SELECT...
Well, <br /><br />Thanks all for your advices, I'm going to do some benchmark tests to see which solution is the best for us.<br />Concerning the...
Thanks you for this answer. Moreover, I've one more question : I've heard that sql server 2005 allows to create UDA (User Defined Agregates)...
Hi, I need specialists advice concerning sql design. Here's the situation : 1 sql table name "users" table but done / design the bad way......
Separate names with a comma.