116 reputation
4
bio website
location
age
visits member for 2 years, 5 months
seen Aug 28 '12 at 6:55

Aug
28
awarded  Commentator
Aug
28
comment SQL Server 2008 R2 - Weekly / Monthly Statistics
can you please tell us how can we track the Schama changes using Auditing? I tried to use SCHEMA_OBJECT_CHANGE_GROUP. My efforts are mentioned in this screenshoot.
Aug
6
comment Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance
ok. Your query is showing Like Predicate and can you tell us something when the query is using =
Aug
6
comment Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance
can you please tell the meaning of hashing the values as stated in query?
Aug
6
comment Does having an index on a VARCHAR column with a lot of very similar starting values have bad performance
Are u using like Predicates or =
Jul
26
awarded  Scholar
Jul
26
accepted How does the database decide which Index to use
Jul
25
comment How does the database decide which Index to use
Need some time to look into it i will revert very soon
Jul
19
awarded  Student
Jul
19
awarded  Citizen Patrol
Jul
19
comment How does the database decide which Index to use
Did you check my first two queries? I understand that these two uses the mentioned indexes in my query. Can you confirm my understanding ?
Jul
19
comment How does the database decide which Index to use
can you please explain a bit more...? Thanks for the reply....
Jul
18
comment How does the database decide which Index to use
@Aaron - as pst told Why does SQL Server use any index in the 3rd case?....
Jul
18
comment How does the database decide which Index to use
Does that mean - in case of 3rd query execution Example1_Index execution is just a random case and it can be Example_Index also ?
Jul
18
asked How does the database decide which Index to use
Jul
10
comment sql bulk delete is much slower?
@JNK Sir, I want to keep the required records somewhere. So either it can be placed in UDT that can have a Unique GUID like name and can be deleted finally in the above process or I can use Local Temporary table. The Table usage will be just to keep the records temporarily.
Jul
10
answered sql bulk delete is much slower?