151 reputation
6
bio website monstermmorpg.com
location Turkey
age 27
visits member for 3 years, 4 months
seen Nov 3 at 0:41

Hello. I am the only owner and developer of web based online MMORPG game MonsterMMORPG. I am a computer engineer from Turkey and i am currently doing MA at computer engineering. I am specialized with C# & ASP.net.

http://www.monstermmorpg.com/

MonsterMMORPG is a Free To Play Browser Based Online Monster MMORPG Game Better Than Online Pokemon Games

You will love it's awesome Monsters

We have many different unique features. So i suggest you to check them out. Our game is similiar with Pokemon games but it is unique. Like diablo and torch light.

You should visit following sites related to us

MonsterMMORPG Facebook

Pokemon Games Lovers Facebook Application

MonsterMMORPG Youtube Channel

Monster Game Forum

Canavar Oyunu Forum

Pokemon Fakemon DeviantArt

MonsterMMORPG Google Plus

MonsterMMORPG Twitter

MonsterMMORPG Review On Browsergamez

MonsterMMORPG Review On mmohuts

MonsterMMORPG Developer Blog At MMORPG.com

MonsterMMORPG Review On onrpg

MonsterMMORPG On GameSpot

MonsterMMORPG Wiki

MonsterMMORPG On 1UP

MonsterMMORPG Digg

MonsterMMORPG Official Google Plus Page


Oct
19
comment How do I find a long running query with process ID, process name , login time, user , start time and duration?
how can we restrict this query for certain database ?
Sep
24
awarded  Tumbleweed
Sep
17
asked Database Engine Tuning Advisor - is number of queries important or not
Sep
14
comment Why isn't SQL Server using my non-clustered index and doing a clustered index scan?
@AaronBertrand i see. so if not all columns are not in the index it is highly possible sql server will ignore it. I am still waiting database engine tuning advisor to finish its process.
Sep
14
comment Can there be any case where it would require additional indexes while all columns compose primary key
@AaronBertrand yes you are right i should have used key columns.
Sep
14
comment Can there be any case where it would require additional indexes while all columns compose primary key
@Lmu92 i see that i said incorrectly. I mean the first column of the index by included column not columns that are included :) In my question it is being : cl_CrawledPageUniqueId
Sep
14
comment Can there be any case where it would require additional indexes while all columns compose primary key
@Lmu92 so indexes are sorted always by the first included column ? even if they are clustered or non-clustered ? In that case having separate date column index would help ?
Sep
14
comment Can there be any case where it would require additional indexes while all columns compose primary key
@Lmu92 ah i see. so if you use only 1 column out of multiple columns of primary key it won't cover them ?
Sep
14
comment Can there be any case where it would require additional indexes while all columns compose primary key
@Lmu92 there is no views and there is no table not name starts with tbl. Well this is my naming scheme as i am the only developer and will be :D ty for answers so you say this primary key wouldn't cover between query. Why it wouldn't cover i were supposing that primary indexes were ordered ?
Sep
14
comment Why isn't SQL Server using my non-clustered index and doing a clustered index scan?
@AaronBertrand yes that is something i accept however my logic is incorrect somehow. It comes to me faster to look index for certain predicates instead of scanning entire clustered index however sql server is not making it. So i am trying to understand reason :D I deleted indexes and analyzing 2 GB tuning trace file to see what suggestions will make database engine tuning advisor.
Sep
14
awarded  Commentator
Sep
14
comment Can there be any case where it would require additional indexes while all columns compose primary key
@PieterGeerkens can you give an example in a separate answer that would be great to see
Sep
14
asked Can there be any case where it would require additional indexes while all columns compose primary key
Sep
14
comment Why isn't SQL Server using my non-clustered index and doing a clustered index scan?
The order of indexes changes things ? Never think of that. Also if i made it != 0 would it change seek instead of scan ? crawlsource is nvarchar max so i am not willing to add it to the index. aren't there anyway to improve orderby query ?
Sep
14
asked Why isn't SQL Server using my non-clustered index and doing a clustered index scan?
Nov
12
asked if database is not shrinked does it affect backup size?
Feb
21
awarded  Scholar
Feb
21
accepted Is it possible to have indexes for like '%*%' type queries
Feb
21
comment Is it possible to have indexes for like '%*%' type queries
So when i set full-text search will i be able to still use the query above ? Or i need different format ?
Feb
21
awarded  Supporter