ScottPletcher (1/31/2013)

---

startdttm was the only column used in all three of your sample queries. If you have other queries that are more representative of the normal work load than...

I totally agree that a clustered index will help performance in...

Thank you Gail for the link.

From the link:

'summary would be: don't change or implement anything without research and without knowing what it's going to affect. '

My quest at the...

siggemannen (1/28/2013)

---

Can SQL Server guarantee that if I issue a command like:

INSERT INTO T(...)

SELECT t.a, t.b, 1

FROM sometable t

UNION

SELECT -t.a, t.b, 1

FROM sometable t

, both "sides" of union will retrieve...

GilaMonster (1/24/2013)

---

ben.brugman (1/24/2013)

---

I'd personally ignore PLE during CheckDB execution. Because it reads the entire database and because it marks pages brought in as 'disfavoured', meaning they'll be the first to...

Bhuvnesh (1/22/2013)

---

it means you have buffer cache issue and IO contentions

see these links

http://www.sqlservercentral.com/articles/Performance+Tuning/analyzingmemoryrequirementsforsqlserver/2498/

http://sqlblog.com/blogs/buck_woody/archive/2010/06/29/the-windows-page-file-and-sql-server.aspx

http://support.microsoft.com/kb/889654/en-us

and...

GilaMonster (1/22/2013)

---

Because it reads every single allocated page in the database and, like all other operations, reads them through the buffer pool. Unless you...

mickyT (1/21/2013)

---

Always love a puzzle 🙂 so here's my solution. I'm not sure if my grouping method will work further down the line, however it seems to work for...

Alexander Suprun (1/22/2013)

---

ben.brugman (1/22/2013)

---

But how is it possible that SQL-server Expects that the memory can be refressed (8Gb of it) in 14 seconds ?

I do not think normal disk IO...

Additional, we now saw the PLE drop from a few thousand to 7 within the 30 second time frame.

Size of the cache at that moment was 8 Gb.

This means that...

Because off another thread I thougth about this puzzle.

Because the puzzle is solved mainly using a lot of REPLACE functions.

Analytical I had allready determined that there would never be a...

Hello,

Take the advise of Gail Shaw (Gilamonster) seriously.

Read the article.

Very probably setting your database to simple en regulary make backups will work for your requirements.

(Steps 1/2/3 in my previous post).

Simple...

purushottam2 (1/19/2013)

---

HI Ben.

Thanks for your promptness,

Only 20 users are using my application, and there is no frequently use of database interaction. And this log file increased up to 96 GB...

Hello I am going offline, but want to give some help.

So I am going to assume that you have a maintenance window where NOBODY is using the database.

1. Make a...

My assumption is that the log file has the size it has because of maintenance actions. This could be scripts you have run or for example ONLINE clustering.

First question is,...