Ok, the answer is a little confusing. It IS millions of transactions but it will not be that much in the future. This is a camera that takes many pictures...

Sorry, my bad. Of course Dup is an exact copy of NestleComments which is a table I made for testing. I have corrected the original query.

Thanks everyone for responding. I...

Suddenly I am in panic and I can't write any SQL code. One time I lost a lot of money on this kind of "program". Since then, I get scared...

Hi Lucas,

I chose your question as a learning exercise for myself. This is what work for me, I hope more experienced members on this forum don't kill me for this...

From my recent experience this is done using a DDL (data definition language) trigger. Of course, it would be only going forward after you set it up, I don't know...

Hi Craig,

Can you help me understand this better? I would not be able to explain it to my rubber ducky for sure, if I had one 🙂 I don't understand...

TheSQLGuru (2/10/2012)

---

Note that you should not concern yourself with objects with less than N pages, where N is probably 500 or even 1000 or more depending on your system.

Question: ...

The fill_factor column in sys.indexes has all zeros for all indexes. If this is the right place to look, then yes they are 0.

But thank you for explaining this fragmentation,...

Fillfactor is 0 and they are all indexes, no heaps. This adds to the confusion.

Just trying to explain what is confusing me exactly is the documentation says anything BELOW 75%...

Hi,

Could you please tell me: I have a very large database with warehouse data for many years and I have a need to enter Russian characters into one column. How...

All the answers so far have been criticism or jokes. Nobody found it useful to know what they ask at real interviews???

Anyway, I am not currently looking for a job...

handing out flyers

advertising manager

secretary for company president

selling flats, land and summer houses

Personally, I hate when people tell me to "Google it" or look in Books Online (everyone knows already there is that option, why remind?) Therefore, I'll try to answer here.

1.

The...

I would be very interested if there is a way to do it from within SQL Server without third-party programming.

I have a similar situation, we are receiving files via FTP...

A Dedicated Administrator Connection (DAC) allows an administrator to connect to a running instance of SQL Server to troubleshoot problems...