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,...

Only saw your second post after anwsering.

Your log file is so big because is logs all datachanges in the database. A write takes about one size of the space of...

What is the size of the datafile('s), and what is the size of the logfile('s).

Maybe the log file is growing and taking up space. In that case backup the logfile....

Spoiler alert, Here is the solution to the puzzle.

Spoiler alert, Here is the solution to the puzzle.

ben.brugman (1/18/2013)

---

-- Puzzle.

--

-- Using SQL I wanted to see what happend with the following...

46 seconds for the 25 000 rows.

About 2 hours for me...

Thanks for your solution, tried to study the solution,

'DelimitedSplit8K' is missing.

So I could not try the solution.

Also I have...

First I used the replace to find which were the undesired chars.

Next I used the...