370 reputation
418
bio website
location iran
age 34
visits member for 2 years, 6 months
seen 20 hours ago

SQL Server DBA and SQL Developer, also get to work with Technologies such as SSIS, SSAS, SSRS, C#


22h
comment Query execute slowly when changed compatibility Level of my database
@Kin. thanks for your comment. I execute sp_recompile command for all of my stored procedure but execution time of my stored procedure not changed.
22h
comment Query execute slowly when changed compatibility Level of my database
@Shanky. I Install CU 4 on my server but execution time of my stored procedure not changed.
1d
comment Query execute slowly when changed compatibility Level of my database
@Shanky. The version of my SQL Server is Microsoft SQL Server 2014 - 12.0.2000.8 (X64). I don't install any CU level of SQL Server until now.
1d
comment Query execute slowly when changed compatibility Level of my database
@Martin. Thanks for all comments. I change trace flag 9481 status to ON and my stored procedure run quickly. This trace flag change query optimizer and use version 70 (SQL Server 2012) of query optimizer. Can I set this trace falg to default status and use query optimizer (SQL Server 2014) and also run my stored procedure quickly.
1d
asked Query execute slowly when changed compatibility Level of my database
Nov
10
awarded  Popular Question
Jul
28
answered Large table with historical data allocates too much of SQL Server 2008 Std. memory - performance loss for other databases
Jul
24
answered SQL Server NULL values UNDO
Jul
2
awarded  Curious
Jun
8
asked Analysis Service Connection String
May
21
awarded  Notable Question
Apr
14
awarded  Notable Question
Mar
19
awarded  Popular Question
Mar
18
accepted Minimum memory required for SQL Server and database
Mar
18
accepted Rebuild Index in system database
Mar
18
awarded  Tumbleweed
Mar
3
asked Rebuild Index in system database
Dec
30
accepted Sql Server Fix Users
Dec
29
asked Sql Server Fix Users
Dec
17
comment Minimum memory required for SQL Server and database
@alroc. Please see my edit2.