compared to MSDB, how important is Model? do you have a recommendation for model?

>>Also, if I have time I check all other queries that run against the table.

Do you run a profiler for this? How do you get exact queries running against a...

I agree.

one of the DB is just non-confidential info that the company wants to be in public mode so anyone can have access for PR.

I believe that status should...

you make it look easy 🙂 I will include them in the key, but be careful of the order.

Do you take the missing_index_details recommendation at face value, or do...

good perspective, Rob.

never mind, I do see it, after all.

i use fn_trace_gettable for the purpose...

Thanks Jack.

3NF+ for OLTP and 0 NF for OLAP? 😎

For CRUD, the reason only SP is advised is because of SQL Injection Attack possibility?

are there any good times/reasons to allow DML from App code?

that should work.. cool..

ok. that confirms that there are DBCC commands running by the 3rd party tool. But should it not be also captured by the default trace. - if i try a...

how can you find how many and what are the varchar(max) columns in the database?

we can find current space from sp_spaceused, and I can divide by number of rows to...

Jason, to get it back if it is corrupted? I hope to have a backup always available. But what is the option if you do not have a backup? a...

I see your logic. It seems too simple, but then why all the extra procedure explained in the article? It is a matter of exact vs approx? (in your method,...

Yes, I see that other regular DBCC commands run and get captured.

Why name it 'DBCC' for a counter?

TheSQLGuru

Are you referring to the maxmemory setting for the server?

thanks

Dan