I have checked DBCC CHECKDB ('DBNAME') WITH DATA_PURITY, it was reported huge currption

CHECKDB found 0 allocation errors and 104 consistency errors in database

Msg 8952, Level 16, State 1, Line...

There is only one Instance.

Yes. I am talking about Primary Key constraint., Not for...

Let me explain the table defination

Table TBL_UploadData_TRAN

Data_ID - column is primary key already defined, but constraint is not added in that PK column. I verified no other columns does...

Hi MyDoggieJessie, thank you for giving such a wonderfull information for finding potential index already exists in database. Mr.Brent Ozar's, sp_BlitzIndex - it is very useful for find idex issues.

Aggressive...

Jack Corbett Thank you for reply..

identifying indexes that may be candidates for dropping or modification? user_update values modified frequently.

Identified that NC INDEX on table,

SP inside, there is one SELECT complex...

Hi,

I checked unused index, As per that script result return value only two column in NONCLUSTERED

total 4 NONCLUSTERED index values as below and Remaining all the column...

it is not SSRS, another application such as aspx.

SQLRNNR (2/26/2014)

---

Is there a time of day that they run slow all the time?

There is no fixed time period, whenever user tried generated reports time running fast & slow, I...

First Error resolved Just refersh that View at source server, then fetch 198768 rows from source database thru linked server..

But i am facing another memory issues while executing that linked...

I will try to tuning that blocking query.

I have configured TEMPDB at initial stage and different location, not in user database files location, Also configured MAXDOP and cost of threshold...

Thanks Gila, as you suggested no need to assign the NOLOCK hint at statement level, it cause of incorrect data will be display in reporting.

Yes. Second one is another blocking...

Due to blcoking another statement, so that query was taking too much duration. maunally executed in SSMS also took 30 min during the blocking happening. attached Actual exe.plan for blocking...

I am checking with profiler, this paricualr Query tooks duration 30 sec for completion at every execution, and CPU is 0 seconds..

I tried as below script and executed with no errors for result in create text file but File is not created in C drive. Pls suggestion me

Create table #Results (

TotalPhysicalMemory_MB...