Can solve my problem use INDEX_REBUILD_ONLINE, that it will be in tempdb and not in memory , right ?

use msdb

EXECUTE dbo.IndexOptimize

@Databases = 'USER_DATABASES',

@FragmentationLow = NULL,

@FragmentationMedium = 'INDEX_REBUILD_ONLINE,INDEX_REORGANIZE,INDEX_REBUILD_OFFLINE',

@FragmentationHigh = 'INDEX_REBUILD_ONLINE,...

sqlbuddy123 (3/26/2014)

---

That error shouldn't cause SQL Server restart. Could be a problem with the I\O Subsystem. Did you check for the SQL Server dump file and analyze it ? You...

Guys, I understand that you dont understand why I want to do, but it looks that we have problem with disk subsystem.

It is not possible to buy new or...

Grant Fritchey (3/26/2014)

---

Memory should manage itself, really. But if you need to clean a query out of the cache, you can get it's plan_handle value from sys.dm_exec_requests or sys.dm_exec_query_stats and...

thanks for response, i am not sure that i asked right, i was after night shift, so i was little confuse.....today night shift i will read these article..

it were two...

thanks for response, I created this job so I really know that it couldnt be cause...

Next point

- I checked that was full RAM - it was full about 3days...

mike 57299 (3/25/2014)

---

My domain login gets me on the machine. I can add files via File Explorer/Windows Explorer. But I can't create a bak file in that same...

Hello,

Do you have same login to this server like you logon on another machines ?

Because I have another login on my pc to domain than on SQL server.

login i...

http://www.brentozar.com/archive/2013/06/the-elephant-and-the-mouse-or-parameter-sniffing-in-sql-server/

http://www.codeproject.com/Articles/459567/SQL-Server-How-Local-Variables-Can-Reduce-Query-Pe

I was reading few articles about it and I tried solution with dynamic sql, but I dont want to use, Somebody knows next solution ?..

With this I got right estimated...

Thank for advice and link

Here is next thread for this query .. http://www.sqlservercentral.com/Forums/Topic1551418-391-1.aspx?Update=1

I have problem with variable = I declare same type like in Design of this table, but estimated...

So still not solved, I tried update statistics on Production and nothing

I have 2test database

1. almost same data like production and I tried this select and is not function -...

So I tried with this script for creating tables and etc on our test database and it looks that it is due to update statistics from TB_RESULT_TOOL, to this table...

I forgot

I rebuild indexes and update statistics, but I have to wait for breaktime for update statistics on TOOL table ( I have one hour to breaktime, so then I...

up