| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 10 months |
| seen | Aug 28 '12 at 6:55 | |
| stats | profile views | 1 |
|
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? |