ichbinraj (2/10/2009)

---

We have recommendations from team- lead to increase the datafiles in db ...he suggested us to maintain ratio 2:1 (datafiles :Processors ). thats what I am planning to do...

eduardo.pin (2/10/2009)

---

I did the first SYSALTFILES select posted after...

TRACEY (2/10/2009)

---

Today it is happening and it appears bi impromptu report blocked the record and the replication inserts etc had to wait.

Usually they set an isolation mode in their...

TRACEY (2/10/2009)

---

Today it is happening and it appears bi impromptu report blocked the record and the replication inserts etc had to wait.

Usually they set an isolation mode in their...

There are occasions...

That is a task for Client-Side "IF" you want to engage on such venture.

There are *many* cases where developers use select * from just to read a couple...

Here is one of the *many* :

http://sqlblog.com/blogs/lara_rubbelke/archive/2007/07/30/smart-index-defragmentation-for-an-online-world.aspx

SORT_IN_TEMPDB reduces the size needed on the destination because the "sort runs" and "mapping indexes" (and version store if online) are not allocated on the destination.

Now, IF you rebuild ALL...

IF you are running this from stored procedure you can use "WITH RECOMPILE"

Sorry:

RCSI = READ-COMMITED-SNAPSHOT ISOLATION.

You can enable it as:

ALTER DATABASE < dbname > SET READ_COMMITTED_SNAPSHOT ON;

Note: You need exclusive access to do that!

Hope it helps.

Looks like someone ran the script to move tempdb from drives and never rebooted the service, which is required!

shri_sastry (2/9/2009)

---

Hello All,

This may be simple, but how do I find out when was the last time the index was rebuilt. I am trying to make...

Backup the log more frequently!

SA (2/9/2009)

---

That is correct, however, how do you explain the growth of the data file when there is enough of free space within the existing mdf.

The database size is 46GB,...

gharris_35 (2/9/2009)

---

noeld (2/9/2009)

---

Unable to do so as the system needs to support multibyte character...