Hi,

Thanks for the reply. Much appreciate it !

I found something interesting from that book as below

"One of the popular questions on online SQL Server forums is: "What is the...

OK. Thanks so much for your comment !

Hi Jeff,

I re-read your explanation . I am still confused with your statement about REORGANIZE.

" On the other hand, REORGANIZE will do it in the space already allotted. The problem...

I am serious 🙁 .. Sad really .. hey I got good news .. my Team just did something on that drive and got 17 GB free now .... 🙂

Thanks so much for your explanation ! Thats kind of you ..

I just got approval to add 1 new drive which is 100 GB so I will move the Data...

Thank you for the reply !! much appreciate it !

1. No maintenance so far

2. we use standard edition

3. Yes the log file is the same drive with data...

Ahhh sorry

the fragmentation level for the first index is very high : 98.77 %

and the second one is : 3.93 %

the fragmentation level will impact on the index size...

Hi Jeff

Thanks for you reply

The largest index is PK_Index1 , size : 15 GB , Pages : 2.051.264

it is clustered Index

The second largest is PK_Index2 , size...

Hi All ,

Thanks for the reply .. Really appreciate it !

The query that I run is :

SELECT

''"'' + oc.[name] + ''"'' AS ''"name"''

,''"'' + ll.[str_Desc] + ''"'' AS...

ScottPletcher (12/1/2014)

---

Also, as additional stop-gap measures:

1) review indexes to see if there any you can drop

2) if you have any heaps, see if they consume a lot of space beyond...

Jeff Moden (11/28/2014)

---

A 1 TB 15k-RPM drive costs less than $300 for a SAN drive. For a local drive, you can get one for about $70. You've probably...

ok . .I will try

arnipetursson (11/17/2014)

---

This is your problem:

2014-11-17 06:04:28.077 The process could not connect to Subscriber 'SERVER2'.

2014-11-17 06:04:28.146 Connecting to Subscriber 'SERVER2'

2014-11-17 06:04:28.171 Category:AGENT

Source: SERVER2

Number: 20084

Message: The process could not connect to Subscriber...

So here is the message from SQL job :

Message

2014-11-17 06:04:02.828 Copyright (c) 2008...

Beatrix Kiddo (11/14/2014)

---

There are a few things you can check:

- what do you see under Replication Monitor? (Right-click on your publication and select Launch Replication Monitor). Any errors or activity?...