I'm gonna dig to find that slide, but Microsoft ran a test and compared perf of tables with CI and the same set of columns as heaps.

On any operation (insert,...

Still better than nothing... but what is the cost of performance for doing this? and what is there to be gained?

I heard a few good comments at PASS about clustered index and reordering. Those don't apply here in this case, but let's just say we have a few beliefs...

Take note of where they work, then wait a few months and send in your resume with more than generous rates :).

Other words that come to mind (after proper warning has been heard) : stupid, wreckless, job buster, career ender, go back to live with your parents...

😛

--Testing to see how the...

Where can I frame this?? :w00t:

Thanks :hehe:.

have you noticed how this works out? L death by sql (dbs) = database bullshit by a DBA.

Please do not cross-post, we monitor all threads.

Topic answered here :

http://www.sqlservercentral.com/Forums/Topic402783-149-1.aspx

Please do not cross-post, we monitor all threads.

Topic answered here :

http://www.sqlservercentral.com/Forums/Topic402783-149-1.aspx

Very simple : if you mess with the system tables in any way (except for selects), then MS has the right to NOT support your application, and they will use...

Ya this is definitly a reporting task. You might want to have a job run every X hours to be able to have a quick notification to HR that...

I c now.

A simple way to do this is something like so : Keep the trigger setup as they are right now.

However, create a new table with only 1 column,...

Shouldn't that be char(13) and char(10)?

Anyhow, what software are you using to watch your e-mails?? My notification are better formatted than this!

That may make some sens... but the question is more : Why did you ask this in the relational theory forum?

Got a link for this problem? I have not encountered that problem anywhere... and I've been around this site a lot yesterday.