Charles Kincaid (5/4/2015)

---

Thanks Gail. I had missed that point.

Toby, the O/S fragmentation does not have anything to do with the shrink. Actually it does not even apply to...

And a third that motion!

It looks like the thread got past that and is back in a productive direction.

sql-lover (5/1/2015)

---

Hi,

I am tuning the following CPU intensive query, which is also a remote query for a given store procedure:

INSERT INTO #t

SELECT top 1 @DOB, col2, col3

FROM Server1.MyDatabase.dbo.MyTable

WHERE col4...

Jeff Moden (5/4/2015)

---

Lynn Pettis (5/4/2015)

---

Jeff Moden (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something...

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix this poorly...

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

WhiteLotus (5/3/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

ZZartin (5/1/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

3gb is teeny tiny as databases go. Since you're at 99% usage on the data, I'd suggest moving this...

totem

Steve Vassallo (4/30/2015)

---

More gas for the fire. Four hour transaction log backups. I am assuming data loss of 4 hours or less is acceptable which is...

For the exclusion part, I would do something like

ISNULL(Anniversaire,'') <> ''

That should handle the empty string and the null problem.

The bigger problem is that the date is stored as...

TheSQLGuru (4/30/2015)

---

SQLRNNR (4/30/2015)

---

Ed Wagner (4/30/2015)

---

TheSQLGuru (4/30/2015)

---

That seems to have been missed. Sadly it is MANAGEMENT/LEADERSHIP that is forcing these...

I was worried that logic on the question would be contradictory to reality.

CDC in tempdb makes no sense.

Ed Wagner (4/30/2015)

---

TheSQLGuru (4/30/2015)

---

That seems to have been missed. Sadly it is MANAGEMENT/LEADERSHIP that is forcing these ridiculous requirements,...

Pro 4

Grant Fritchey (4/29/2015)

---

SQLRNNR (4/29/2015)

---

Steve Vassallo (4/29/2015)

---

Our company was just acquired by another. They DBA team there added some jobs to our servers and one was a DBCC Shrinkdatabase command...