Ha, so on second look, the same thing answers the second question. When the function does data access (the database numbers table) it can't be deterministic, so SQL Server...

Flo,

The first part of your question is easy: SQL Server marks all functions as non-deterministic unless they are schema-bound. Schema-binding a function forces the engine to evaluate the content...

Online rebuilds generally result in greater residual fragmentation than offline rebuilds. For the 'best possible' results REBUILD offline, with MAXDOP = 1, and SORT_IN_TEMPDB = ON. Also make...

Are the tables in question heaps? (no clustered index)

The script explicitly excludes heaps. The only way to defragment a heap is to create a clustered index on it, and...

This might assist:

-- Create a test table variable

DECLARE @CallLog

TABLE

(

...

Feel free to share! PM or The Thread...

Florian Reischl (11/7/2009)

---

As long as I...

Only one set of jobs will be enabled, depending on which server is primary.

I would encourage you to try this out in practice (you can log ship from and to...

Newbies??? Flo - in the words of a very popular drink over here..."yeah, right!"

http://www.tui.co.nz/

I know I'm late to this party, but I have to say:

Only shrink if you absolutely must reclaim disk space.

Shrinking moves pages from the end of the physical files one...

In SQL Server, 'endproc' is not implied, it must be explicitly created as a label.

A label in SQL Server consists of a single word followed by a colon, so:

GOTO endproc;

PRINT...

Kevin,

To answer your question literally, the closest analogue to a synchronized method call would be a transaction (as Florian described) running at the SERIALIZABLE isolation level.

I think it is really...

You're very welcome. I'm hoping that if I do it enough, future posters will get the hint 🙂

I know not everything in...

Hey Lowell,

I have an uneasy feeling that I am misunderstanding you, but I believe the reference was to the SQL Server Logs (as shown in SSMS):

Paul

The user 'rpp' is a SQL...

It allows you to import data to, and export data from, SQL Server databases.

It is pretty configurable (you can import and export...