MadAdmin (5/29/2015)

---

You seem to get Model_Id from a window and pass it up to an outer window, and that value does not get used in a filter, join or select...

Grant Fritchey (5/28/2015)

---

First question, did the execution time change with the removal of DISTINCT with the original indexing scheme?

Next question, did either of those indexes get used? Did you check...

GilaMonster (5/28/2015)

---

WhiteLotus (5/27/2015)

---

I just tested the query by eliminating DISTINCT ..

the result is :

(45108 row(s) affected)

Table 'project_text'. Scan count 1, logical reads 2017, physical reads 0, read-ahead reads 0, lob...

Grant Fritchey (5/27/2015)

---

The execution time is the same? I'm not surprised the reads are the same. You're still scanning 45,000 rows.

There just isn't anything to tune in the query here.

Wild...

Grant Fritchey (5/27/2015)

---

Despite the fact that...

Jeff Moden (5/26/2015)

---

WhiteLotus (5/26/2015)

---

Thanks for the link . NOTED 🙂

Thanks for the link . NOTED 🙂

I attach the execution plan .

Project text --> Table A

Below query is clearer I think ( The query that I run )...

GilaMonster (5/25/2015)

---

You're not going to get any better than that. By the looks of the reads, you're fetching the majority portion of the table and all the columns. As long...

My team said that even if We don’t set up the maximum memory setting in DEDICATED SQL server , SQL will adjust memory usage dynamically and always leave 1 or...

The min server memory option specifies the minimum size to which SQL Server can

shrink the buffer pool when under memory pressure; it does not specify the minimum

amount of memory that...

Great . I will read it soon ! Thanks a lot

How do you prove it wrong ?

any article about it ?

Thanks for the reply 🙂

but based on this article from technet

https://technet.microsoft.com/en-us/library/ms178067%28v=sql.105%29.aspx

"Allowing SQL Server to use memory dynamically is recommended; however, you can set the memory options manually and restrict...

Jacob Wilkins (5/4/2015)

---

Like Jason said, this is recorded in the default trace, so you can just query it to look for growth events.

Something like this would do the trick:

DECLARE @filename...

SQLRNNR (5/4/2015)

---

Here is an article with links to other articles.

http://bit.ly/FileSizeChange

I am trying to find the pertinent info link/info for the default...