I just re-read this ….. "only use numerical types for maths"??????? how about a foreign key  to person.status - if there are only 3 statuses then tinyint…. massive...

Joe...

yes he can be slightly "pernickety"... 🙂 but he does have a good knowledge of standards (that I ignore) 🙂

I would compare the contents to other similar data that you might have elsewhere, for consistency. For example if you are using varchar(80) for names of people or places,...

I'm going to be very kind, a lot of people would have shouted.

I/O is     input/output (sometimes refered to as Inbound / Outbound)

throughput means how much traffic you get....

I was wondering why...

I fell foul of this recently and jeff's trick cured my issue.. worth a try and although it's not required by ansi 92 syntax it is a good practice to...

Great ideas and much appreciated...having the articles in place prevents the dropping of tables.  Not knowing which table is going to get dropped is the issue there...then when a...

OK - what if there are 200 tables(I made that number up) that need replicating? wow, sql agent is going to get busy and run out of threads quite soon...

the only piece of advice I can give you is don't use varchar for a date field, don't use float for anything and think about the maximum size of any...

run a quick dbcc opentran against that database - then figure out what that spid is doing

it might not be as bad as john says. it could be a tiny...

here's a thought, could it be possible to script up something  that re-initialises the subscriptions and runs the snapshot job when a DDL event occurs (e.g drop table)...

• This reply was modified 6 years, 2 months ago by MVDBA (Mike Vessey).

I suppose lmgtfy.com could be construed as "sarcastic"? but it is tempting sometimes.

Better to be a nice DBA and not discourage people trying to learn.

BAD DBA for even thinking about...

We frequently raffle off Steve's shirts at the Redgate Summit events. I'm sure that will continue. Although, for everyone's comfort, it's a shirt he is not wearing and hasn't...

here's a thought, could it be possible to script up something  that re-initialises the subscriptions and runs the snapshot job when a DDL event occurs (e.g drop table) you could...