Sounds like a distribution database.

Thanks Grant.

Thank You

Jeff Moden (3/14/2014)

---

JoshDBGuy (3/14/2014)

---

I will be working on a plan to import data from multiple sources (say about 1000 sources). These sources will have different data, however, the actual table...

Thanks a bunch, much easier than I thought.

Great, thanks so much!

djj (3/4/2014)

---

Log Shipping takes care of stored procedures, et al. The thing it does not (at least how we use it) do is to keep the jobs and security...

Sean Lange (2/28/2014)

---

JoshDBGuy (2/28/2014)

---

Do you have a best practice for cursors? Just don't use them at all or only in certain situations? I tend to use them for small sets...

Do you have a best practice for cursors? Just don't use them at all or only in certain situations? I tend to use them for small sets of data, such...

You can put the witness on the mirrored server but that's not generally a good idea. I believe, and someone else can probably confirm, that you can use any version...

Depending on how many rows you're looking at, you can use a cursor or you can probably use a loop with IF then statements with a temporary table or tables....

My bad, I think I understand what you're looking for now. Does the above query work? I edited it. I doesn't have the filegroup info but you can add that...

Here you go, you can modify this to get more data.

SELECT DISTINCT

OBJECT_SCHEMA_NAME(T.[object_id],DB_ID()) AS [Schema]

,T.[name] AS [table_name]

,I.[name] AS [index_name]

--,AC.[name] AS [column_name]

,I.[type_desc]

--,I.[is_unique]

--,I.[data_space_id]

--,I.[ignore_dup_key]

--,I.[is_primary_key]

--,I.[is_unique_constraint]

--,I.[fill_factor]

--,I.[is_padded]

--,I.[is_disabled]

--,I.[is_hypothetical]

--,I.[allow_row_locks]

--,I.[allow_page_locks]

--,IC.[is_descending_key]

--,IC.[is_included_column]

,PS.AVG_FRAGMENTATION_IN_PERCENT

FROM

sys.[tables] AS T

INNER JOIN sys.[indexes] I ON T.[object_id]...

You don't need to set up a central management server if you're the only DBA and you are only hitting one server.

You can run something like this,

CREATE TABLE #TEMP1 (

DATABASE_NAME...

Thanks again. Some great information.