Jobob Smith (10/16/2007)

---

Does the constant HAVE to be stored in a table??

Would it not be easier to just have the UDF return the value? (it is constant after all)

as in:

CREATE...

Bruce,

If you can consolidate databases you could reduce the number of agents "specially" LogReaders. If you cannot then either you will need a big powerful machine or use a different...

S T A R C R AF T hands down. I have played ( read: "waisted so much time" ) so much that I am ashamed to confess how much...

Being in both sides of the fence what really I like the least is that the "interviewers" many times could ask corner questions. That not only is unfare but also...

After almost a month I don't think this OP is coming back ... 🙂

Linda,

Make sure your logs are big enough so that you are not getting autogrows... In addition you should also check that "autoshrink" (database property) is also "off"

I know that...

Glad to know you solve the problem

Something does not sound right. Can you change distribution not to keep rows "temporarily" on the distribution database and try re-running the cleanup job ?

can you post the results of:

select count(*) from sys.dm_tran_locks

Hopefully this is what you want:

SELECT db_name(database_id) as db

, object_name(object_id,database_id) as table_name

, min_record_size_in_bytes

, avg_record_size_in_bytes

, max_record_size_in_bytes

FROM

sys.dm_db_index_physical_stats(NULL, NULL, NULL, NULL , 'DETAILED')

WHERE db_name(database_id)...

It is ALZDBA 😉

One piece of advice script out local Jobs before changing the name!!!

For Such large setups either you have a "brutal" SAN that can do split mirror or you use some sort of log shipping. If you think you can restore such...

Books Online is your BEST friend when it comes to TSQL. Keep that in mind

OPENROWSET though gives you the ability to filter in the same query. If you don't need that flexibility you should follow Jeff's advice.