You should also consider using option "SORT_IN_TEMPDB = ON" in the rebuild. That should give you about the same space gains without having to use a separate fg within...

1. The only way to rebuild heaps is to add a clustered index; you can then drop it. Since, however, adding or dropping a clus index requires rebuilds...

SELECT

MatchID, KeyCode,

CASE KeyCode

WHEN 'MTDT' THEN CONVERT(varchar(100), MatchDate, 101)

...

Safer might be:

WHERE

FtgNr NOT LIKE '[^0-9][^0-9]%1'

Unless you really want "alphabetic" rather than "non-numeric" as originally stated. Spaces, underscores, periods, etc., would fail this test but pass the other one...

RVO (11/4/2013)

---

ScottPletcher,

We don't have authority to alter table definitions.

This is Financial Application database by third party.

We don't own the database.

We even create all our custom code in a separate (Diff_Data)...

I think the clustered index should be ( accounting_period ) or, if you prefer, ( accounting_period, prj_code ) rather than the other way around. I don't think phase_code needs...

Please post the DDL, including all indexes, for the "prj_detail" table.

If the clustered index is on an identity column, you should almost certainly change it to "accounting_period" instead. This...

Instead of DDL_LOGIN_EVENTS, you can use DDL_SERVER_SECURITY_EVENTS, which covers a much wider range of statements. See BOL, "DDL Event Groups" for more details.

You'll need to use EVENTDATA() from within...

Kurt W. Zimmerman (11/1/2013)

---

clayman (11/1/2013)

---

Kurt W. Zimmerman (11/1/2013)

---

clayman (11/1/2013)

---

Kurt W. Zimmerman (11/1/2013)

---

If I'm going to move data from one server to another via Import/Export I will script out...

Not that familiar with Citrix, but maybe there is some way to get it to pass the original login info? Perhaps as some type of comment, or by writing...

SELECT

@paid =

CASE WHEN day_of_week = 5 /*Sat*/ THEN CASE WHEN @age <= 10 THEN 300 ELSE 500 END

...

-- one more test data row

INSERT INTO MyTestTable (ID, Col1) SELECT 4, 'a longer string value1 / a much much much much longer string value2 / whatever / whatever /...

Actually I would never have seen this except that it was posted here ... I only check a limited number of threads as I don't have the time for all...

Definitely go to a local user group. In particular, get a good mentor to help you learn. With the sheer volume of what you have to learn, a...

Great, glad it helped!

Btw, use DBCC commands such as those above to do file shrinks and other such db maintenance tasks, not the SSMS gui, which can be flaky for...